[SOLVED] mysql LIKE search??

[Boo-urns]

I'm trying to get a search where the user enters in anything say "hat" I want to search a subject that contains "hat" but not "what" I can get the results just fine however I'm still pulling in the "what"

 

<?php
$message_query = "SELECT * FROM messages WHERE title LIKE '$title' AND viewable='Y'";

?>

 

I've also tried using \_ but am unsure on the proper usage as i'm trying to just find a string that finds that exact word.

 

Thanks

Corey

[rameshfaj]

if u want to have the word hat anywhere in the middle then try this:

...where value like'%hat%'..

and if u want the word to be starting one then try:

........where value like 'hat%'...

and so on.Only u have to do is to try various combinations of the value and the percentage sign.

[xProteuSx]

The '%' symbol is the wildcard in this case ...

[Boo-urns]

Thanks! %$title works perfectly! =D