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!!!
Keep in mind that any created indexes can not be used since you are not matching from the start of the varchar.