search condition

joon

and (job like '% teacher%' or job like '%professor%')";

Above code will call ( teachers + professors)

I like to call (teachers - math teachers).

I mean that every registered members who entered his job as teachers,
but exclude math teachers.

It would be something like below

and (job like '% teacher%' and job like '%! math%')";

I don't expect above code does work, but I expect you understand my intention.

shawon22

add an extra field for example department and modify ur query like this

WHERE job like '% teacher%' or job like '%professor%' AND department = 'math'

joon

Originally posted by shawon22
WHERE job like '% teacher%' or job like '%professor%' AND department = 'math'

It looks like I want to call math teachers or math professors.

I actually like to call teachers minus(-) math teachers.

I meant all teachers except math teachers.

thessoro

AND department <> 'math'
or
AND department != 'math'

joon

although I tried to put your code in my php page lots of time, I didn't succeed, yet.

Nexts are some of my trials.

(1) job like '%teacher%' and department  != "math"
(2) job like '%teacher%' and department  != "%math%"
(3) job like '%teacher%' and job.department like !="%math%"

I can't get how I make the code workable.

Do you explain How to apply your code in a little more detail?

thessoro

it should work. What error message appears?

there is a lot of ways of doing it, for example:

-having both department and job fields

job like '%teacher%' and department <> 'math'
job like '%teacher%' and department != 'math'

job like '%teacher%' and department NOT like '%math%'

having just the job field

job like '%teacher%' and job NOT like '%math%'

this just will take "language teacher", "science teacher", but no "math teacher".

an advice is to put your querys in the mySQL command-line client (if you have the chance to) or in the phpmyadmin SQL textarea in order to check if they work before writting any php code.