Search for row containing word.

[Edwin_Okli]

I want to create a php search that finds word inside a particular row inside rather than the user have to type an exact value.

So that instead of:

$queryv = mysql_query("SELECT * FROM table WHERE word='".$id."' ORDER BY id ASC");

it allows for the word to be perhaps the second word in a given item.

Any help would be really appreciated.

[johanafm]

http://dev.mysql.com/doc/refman/5.1/en/string-comparison-functions.html#operator_like

like '%word%'