DELETE syntax

[Anon]

hi,

i want to delete rows from a table excluding NOT like "%XXX%" and "%PPP%"

can this be done?

thanks in advance,

brenda brewer

[toma42]

delete from table where x like '%'

Check a SQL beginners guide...there are a ton of good tutorials on the net.

[Anon]

hi,

i've checked them. there is a way to delete multiple rows by date but i can't find any to do it by alpha.

brenda

Tom Anderson wrote:

delete from table where x like '%'

Check a SQL beginners guide...there are a ton of good tutorials on the net.

[[deleted]]

You may want to "RTFM" about the delete syntax.

the DELETE statement understands all the WHERE clauses that SELECT does.