How do I write a query for a Oracle database when I have several "like" values for the same column (in my example data "name")?

My example data for table "address":

name like "John"
name like "Jon%"
name like "Jonathan"
name like "Frank"

Is there something like IN() with LIKE in Oracle or do I have to write it for each value OR separated?


Using OR would be the way to go, yes.

  • 8
    Possibly the shortest valid answer the site will ever see. – Philᵀᴹ Apr 15 '13 at 18:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.