How do I show mysql query results for fields that contain certain data?
Posted
by user272899
on Stack Overflow
See other posts from Stack Overflow
or by user272899
Published on 2010-03-26T19:58:47Z
Indexed on
2010/03/26
20:03 UTC
Read the original article
Hit count: 316
I have a mysql query:
$query = "SELECT * FROM movielist WHERE genre = 'comedy' ORDER BY dateadded DESC";
I need to change it so that it selects from movielist where genre contains 'comedy'.
(Note: that my genre field will often contain more than one genre example "comedy, action, drama".
© Stack Overflow or respective owner