Data Assist search and mysql setup to allow multiple word keywords to be seen as one
I am try to work out how to allow a group of words to be seen as one to help my data assist search to be more effective. What I am wanting to do is this. If someone asks a question in a search field i.e " what are the hidden charges for lacie external hard drives?". this question will then search the keyword field of my mysql table to search for any reference for the keywords I have given i.e "hidden charges" and "lacie external hard drives" which are seen as on keyword or key phrase. But what is happening at the moment is the search is searching for any word that matches instead of groups of words.
Is there a way to group words so that data assist search sees these phrase as one entity no separate entities?
Is this done in the mysql table were I would use a seperator or something so the entry in the keywords table would be hidden-charges and lacie-external-hard-drives or something like that.
Many Thanks as always for you help.