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,
>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
Thread
Correct syntax?Steve Pennington11 Jan
  • Re: Correct syntax?Paul DuBois11 Jan
    • RE: Correct syntax?Steve Pennington11 Jan