search condition

[dotJoon]

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's 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.

[anode]

If you're running MySQL 4+, take a look at full-text search.

[dotJoon]

Where is the full-text search article?

[VisualMind]

The correct syntax is:

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