php: mysql .. i donno.. just read this

[Anon]

ok i dont know much about php and i know even less about mysql.. so can somebody tell me how do i search a database fields content for a certain word ? like say i had a dvd database and i wanted to search all the titles for the word 'blood'.. how do i do that ? 🙂

thanks for your help !

[Anon]

Have a LIKE clause in your SQL query so that it reads something like
"SELECT * from books where title LIKE '%$search%'".

...where in your example $search="blood";