select from table

[Feckie]

Hi,
Is it possible to have multiple words like "Comedy Action SciFi" in a Table, then select one of the words ie


$result = mysql_query("SELECT * FROM `films` WHERE Extras = 'Comedy' ORDER BY `Title`");


I have tried the above, Is there a like command ?


OK Sorted It

$result = mysql_query("SELECT * FROM `films` WHERE Extras LIKE '%Comedy%' ORDER BY `Title`");