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
