I have the following query that pulls the data from a mysql database.
$query="SELECT sid, name, status, task FROM supervision WHERE name = 'employee1' AND active='1'";
The above code works great. I'm trying to add to it but can't figure out how to make it pull all task except any that is listed as work.
How would I edit the query to display all the task except any listed as WORK?