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?
Best Answer
Using
OR
would be the way to go, yes.