View Single Post
Old 02-20-2013, 07:11 PM   PM User | #10
Old Pedant
Supreme Master coder!

 
Old Pedant's Avatar
 
Join Date: Feb 2009
Posts: 23,172
Thanks: 59
Thanked 3,993 Times in 3,962 Posts
Old Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to all
??? That didn't work?

Maybe you need the table qualifier in there?

And why the excess of % characters?

WHERE g.genre LIKE '%s%'

But of course that will find *ANY* genre that has the letter "s" (or "S" -- SQL is not case sensitive) in it.
__________________
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
Old Pedant is offline   Reply With Quote