[SOLVED] MySQL Search Query

[gazfocus]

I am trying to create a search page which will pull its results out of a MySQL database and I have got this working fine, but is there a way I can search for say title CONTAINS rather than title EQUALS so I can search for one word in an entire description?

 

Thanks

[IsmAvatar]

SELECT * FROM table WHERE name LIKE "%val";

 

where % is a wildcard.

 

"%val" searches for strings ending with "val"

"val%" strings starting with "val"

"%val%" strings containing "val" anywhere.