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

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??

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

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

 $query = "select EMP_ID, EMP_Name from EMPLOYEES where EMP_ID <> $emp_log";

I think that you know who is log by using a session var, so the var $emp_log must be get from the session var, ex.

 $emp_log = $_SESSION['emp'];