Putting the word 'Perl' in the title does not make this into a Perl question. :-)

However, your problem is almost certainly caused by precedence. Look at the rules for operator precedence in the MySQL documentation. You will probably need to use parentheses to force the conditions to be evaluated in the order you intend.

Impossible Robot