[Solved] Select all rows but one [closed]

by

[ad_1]

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

[ad_2]

solved Select all rows but one [closed]