SQL Order

[Sprite]

Hello,
I search order to SQL. I need delete all acount where not id= 1 and not id = 2 . Someone would write such a command to SQL?

 

[Rab]

DELETE FROM accounts WHERE id=1; try that

 

[Paxton]

DELETE FROM accounts WHERE id NOT IN(1, 2)

OR

DELETE FROM accounts WHERE id != 1 AND id != 2

 

[Sprite]

DELETE FROM accounts WHERE id NOT IN(1, 2)

OR

DELETE FROM accounts WHERE id != 1 AND id != 2

When I use

DELETE FROM accounts WHERE id != 1 AND id != 2[/QUOTE]

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

 

[Paxton]

near " ? There is no " in that query, copy it properly I guess, and I guess use OR instead of AND my mistake I guess.