search for: textsearchfun

...able to find records that match the text column in some way. I know about doing wildcard 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...