如何在mysql中使用多个和or运算符

Question

i use the following statement but it does not working properly.

$query = "select * from employee where status ='Active' and employee_id! ='".$data['employee_id']."') and (first_name like '$data%' or last_name like '$data%' or batch like '$data%' or job_title like '$data%' or company like '$data%' ORDER BY first_name";
      $result = mysql_query($query);

Like i need to fetch all result but not employee_id=5; but i get the employee_id=5 result;is there any issue in query and other simplest way to use this query

Answer 1

in your code $data['employee_id'] and like '$data% use both same variable you need to change $data for search value. it is overwrite.

do this and check