Results 1 to 1 of 1

Thread: select from table

  1. #1
    Join Date
    Dec 2005
    Posts
    28
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Default select from table

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

    Code:
    $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

    Code:
    $result = mysql_query("SELECT * FROM `films` WHERE Extras LIKE '%Comedy%' ORDER BY `Title`");
    Last edited by Feckie; 09-05-2009 at 12:58 PM.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •