List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 11 2000 12:33am
Subject:Re: Correct syntax?
View as plain text  
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,
>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
Correct syntax?Steve Pennington11 Jan
  • Re: Correct syntax?Paul DuBois11 Jan
    • RE: Correct syntax?Steve Pennington11 Jan