Andi Muskaj1,664 Points
Is there a way to combine the three names using "LIKE IN"?
Is there a way to combine the three names, instead of using "OR name LIKE..." three times?
Giovanni Esposito7,816 Points
You can use the in clause, for example
select * from students s where s.name in ('Andi', 'Rose', 'James');
Carsten Dollerup9,276 Points
There is not, but as you get to more advanced methods (INNER JOIN) you can make statements that have the same effect. Look at this thread on stackedoverflow and go down to the answer from Adrian Staander who's answer I'm referring to losely here :-) stacked overflow