Louis Selvon wrote: >I have a string for e.g. called "this is a test" . I would like to search the >SQL databases to see if any of the words in that string can be found in the >forbidden words sql database. The databases itself just have one column with >rows of restricted words. A sample of this DB is shown below > >1. select BadWords FROM WordsTable WHERE "this is a test" LIKE BadWords; >2. select BadWords FROM WordsTable WHERE "this is a test" LIKE "%BadWords%"; >3. select BadWords FROM WordsTable WHERE BadWords LIKE "this is a test"; > > So you want to find all the words which are a substring of the string you pass in?
I don't have mysql around to test on but the query you're looking for uses LOCATE. Something like this: select BadWords from WordsTable where locate (Badwords, "this is a test"); % won't help. It's just a glob basically. HTH James. -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
