My site is using the Google, Amazon API's to provide search engine results. What I'm wanting to add is the ability to throw in a box with results from my sites have keywords that match the search query.
Right now I'm playing with using LIKE in a SELECT statement (SELECT * FROM `geniesites` WHERE `keywords` LIKE '%two words%'). This works as long as my keywords match the query. If someone searches for words two, nothing comes up.
Is there a better way to do this? I'm not looking for an extremely relavant result.
I'm storing the keywords in Mysql in a text record. The keywords are separated by commas.
Thanks,
Marion Hall
Right now I'm playing with using LIKE in a SELECT statement (SELECT * FROM `geniesites` WHERE `keywords` LIKE '%two words%'). This works as long as my keywords match the query. If someone searches for words two, nothing comes up.
Is there a better way to do this? I'm not looking for an extremely relavant result.
I'm storing the keywords in Mysql in a text record. The keywords are separated by commas.
Thanks,
Marion Hall