[Solved] Select all rows but one [closed]

by


Use <> or != as an not equal to operator.

SELECT * FROM member WHERE personID <> 123;
SELECT * FROM member WHERE personID != 123;

If you want to exclude multiple IDs:

SELECT * FROM member WHERE personID NOT IN (1,2,3);

4

solved Select all rows but one [closed]