MySql：如何从表中删除行除了具有特定ID的行

Question

I have an html table with checkboxes. Users are permitted to delete rows from that html table except one specific one, whose value is hard coded in the DB.

If a user accidently checks it regardless, I want my server code (php) or even better the MySqL to run a delete query for all the rows they checked EXCEPT for that 1 specific row. So,something like this( which is wrong):

DELETE FROM table_name
WHERE row_id = some_value
EXCEPT row_id = some_value; 

Many thanks !

Answer 1

DELETE FROM table_name WHERE row_id NOT IN (do_not_delete_this_value );

do_not_delete_this_value will be the id of the row you don't want to delete, rest all records will get deleted.