Feckie
09-05-2009, 10:45 AM
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`");
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`");