[SOLVED] 2 'LIKE'

[dachshund]

How can I put LIKE '%interview%' and '%feature%' as well?

 

$sql="SELECT * FROM content WHERE `section` LIKE '%interview%' ORDER BY date DESC LIMIT 1";

 

[abazoskib]

"like" this: 

 

$sql="SELECT * FROM content WHERE `section` LIKE '%interview%' AND xxx LIKE '%feature%' ORDER BY date DESC LIMIT 1";

 

just re read your post, if you want section to be like '%interview%' or '%feature%' then use OR

 

$sql="SELECT * FROM content WHERE `section` LIKE '%interview%' OR `section` LIKE '%feature%' ORDER BY date DESC LIMIT 1";

[dachshund]

yeah was OR, thanks!