>You want to do BadWords LIKE '%a string test%' Just tried the above, but it cannot find that "test" exists as a bad word in the db BadWordsTable. The output I get is shown below
--------------------- mysql> select BarWords from BarWordsTable where BarWords LIKE '%this is a test%'; Empty set (0.00 sec) mysql> ----------------------- So still won't work. Louis. Andrew Bennetts <[EMAIL PROTECTED]> wrote: On Tue, Aug 13, 2002 at 05:41:26PM +1000, Louis Selvon wrote: > string LIKE pattern [ ESCAPE escape-character ] [...] > I think I need "pattern" to have the "% %" in between, but the problem is that > Once I put "BadWords" in the quotes "%BadWords%" SQL no longer recognises it > as a column in that table. You want to do BadWords LIKE '%a string%' not '%BadWords%' LIKE 'a string' From your description, it sounds like you might be trying the latter, when you should be trying the former. -Andrew. -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
