I've got a table with a column that holds a comma seperated list of keywords. I'm just not seeing the solution right now.
I've got a keyword search where the user can put in a comma seperated list of keywords. I need the query to search the DB to see if any of the keywords match the keywords in the keywords column. I'm sure it's right in front of me -- John Wilker Writer/Web Consultant www.johnwilker.com / www.red-omega.com Without pulling those lists out into a more normalize structure, the first thing that pops into my head is a series of like matches. WHERE Keywords LIKE '%KeywordMatch1%' AND|OR /*Depending in if they need to match one or all*/ Keywords LIKE '%KeywordMatch2%' AND|OR Keywords LIKE '%KeywordMatch3% /*continue until all keywordmatchs are accounted for. Not very pretty, and I doubt it would be a quick performer. -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226130 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
