I am trying to implement a search engine on my site, which all content is stored in mysql. I am having troubles getting the queries to return anything but the exact matches, which I know is an issue. How can I get around that ?
If someone does a search on "Help", I use queries with "like" statements that will only return instances of "Help", but not "help" or "HELP", etc... I would like to return these in the results while not changing the way the data is stored in mysql (Had someone recommend I store all data as lowercase, then I just have to search the lowercase...)
Thanks for any help..