searching a mysql database

[id123]

hi,

is there a function in mysql where the search string is used to find anything containing it. eg if you searched \"american\" then on a film datbase you would get american pie1, american pie2, american wedding, american werewolf in london etc etc

 

so far i have tried select * from dvd where title = $title

 

 

hope that makes sense coz it kind of dont 2 me!!!!!

thanks

[Goochi]

SELECT * FROM DVD WHERE title IS LIKE \'*$title*\'

 

or something similar.. it something with wildcards..

[Deadmeat]

SELECT * FROM DVD WHERE title IS LIKE \'*$title*\'

 

or something similar.. it something with wildcards..

$result = mysql_query(\"SELECT * FROM dvd WHERE title LIKE \'%title%\'\");