Delete everything but *sql?

Question

PHP

There are a lot of lines, you need to delete everything except a certain one, for example,
all records with user_id = 21, but leave the one with delete = not
?
As far as SQL queries are not selenium, I don’t understand how to use the NOT / IN operator
Please tell me

Answer 1

I read documentation aloud. Expensive. Prepayment.
delete from table where not ((id=21) and (delete=not))
write down your question in English. 90% of the questions will end. The rest is in the dock.