Databases Modifying Data with SQL Deleting Data From a Database Review and Practice

Andi Muskaj
Andi Muskaj
1,664 Points
Posted by Andi Muskaj
Andi Muskaj
1,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?

Thanks!

2 Answers

Giovanni Esposito
Giovanni Esposito
7,816 Points
Giovanni Esposito
Giovanni Esposito
7,816 Points

Hi Andi,

You can use the in clause, for example

select * from students s where s.name in ('Andi', 'Rose', 'James');

Carsten Dollerup
Carsten Dollerup
9,276 Points
Carsten Dollerup
Carsten Dollerup
9,276 Points

Hi Andi,

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

Best regards,