searching on a wildcard

assume that in the code below, 'a' is a string passed from a search form
How can i get it to search a mysql field on that string, because in the example below, it would only return those records that matched the string exactly i.e all records with a requestDetails value of 'a'



I want it to return all records that have an 'a' anywhere in it

is it what you're looking for?

tried the following



where I know at least one record has the word display in the field I am searching, and it came back no result

any other thoughts?

I think veedee's suggestion is what you are looking for.

Try replacing the equal sign in your query with the word LIKE

He did'nt realize, somebody posted a reply. We posted almost the same time.....

thanks guys, I have tried it and it is working great, another problem solved