如何使用sql隐藏表中的特定行

Question

I want to show all data from "employee" table except the details of user which is logged in?

eg:

EMP_ID | EMP_Name

  1    |  Mike
  2    |  Peter
  3    |  Drake
  4    |  Oliver
  5    |  Andrew

Suppose, my current login user is "Peter" whose EMP_ID is 2, so I want to show table like this...

EMP_ID | EMP_Name

  1    |  Mike
  3    |  Drake
  4    |  Oliver
  5    |  Andrew

Basically I want to hide the details from table of current user. Please help me how to achieve it??

Answer 1

Essentially you have to select everything you want and eliminate what you don't want:

SELECT *
FROM `employees`
WHERE `EMP_ID` != 2; -- eliminates Peter