I am making a search on my website so that a user can search for something and that it will take what they searched for and look at all the keywors of all the rows in the Database.
I have a basic table that holds keyword_id, fuzzy_keyword (metaphone), and actual keyword. I have a string that can contain anywhere from 1 - 6 words. I need to return all the keyword_id of all the keywords that are found in the string.
Here is an example:
$keyword_string = "running places: boulder, colorado";
keywords in database (potential match yes/no):
running (yes)
running boulder colorado (yes)
running denver colorado (no)
running colorado (yes)
boulder, colorado (yes)
frisco colorado (no)
running new mexico (no)
Thank you for your time.
