search for: mysqltextsearchfun

...dcard searches with % characters but i need to do this in a backwards kind of way. I want to find records that will match some part (or all) of the input query string. Example: - in my db i have the string "textsearchfun" (note all one word) in a text column - the input query is "mysqltextsearchfun" (also all one word) - output should be the row that stored "textsearchfun" the string "textsearchfun" matched a piece of the input query string. The way i think the wildcard search works is the other way around. It tries to find the records where the input query string...