Wildcard WHERE Query Problem!!

Hello,

I currently have search functionality set up on a web tool i am building.
I have a "keyword" search which uses the wildcard function to query a specific word.

My problem is this:

If i search by keyword and search say - "how". I only get results returned where the keyword was at the beginning.

e.x.

How will i make money?
How will I get home tonight?

and not

do you know how to do this?
she asked me how i can be so mean.

see what i mean? How can i have the wildcard return results where there is an instance of that keyword mid sentence?

here is my search string:

elseif($SearchBy=='Keyword')
{
$query1= "SELECT * FROM curiosities WHERE Curiosity LIKE '".mysql_real_escape_string($Query). "%"."' $sort";
$dropdownSearchBy = "Keyword";
$dropdownSearchByValue = "Keyword";
}


Thanks!!!

 

Add another wildcard character "%" before the keyword, so statement is LIKE %keyword%

 

youuuuu rock. thank you much.

 

Keep in mind that any created indexes can not be used since you are not matching from the start of the varchar.