At 5:04 PM -0700 2000-01-10, Steve Pennington wrote:
>I'm trying to delete records from a table
>
>It has a column named keyword and I want to delte all rows containg a, the,
>and
>Take a look.
>
>DELETE FROM hyperseek_keys
>WHERE keyword IN ('a', 'the', 'and');
>
>Is that the correct syntax? I tried looking it up but I couldn't find
>anything specific.
That will delete records where the keyword column is exactly equal to
'a' or exactly equal to 'the' or exactly equal to 'and'. Is that what
you want?
--
Paul DuBois, paul@stripped