I’m doing somethign wrong because I received the following error:

———–
#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘– 1 WHERE mail in (select mail from drupal_users where mail=2)’ at line 1
————-

This is how I implemented the query..

UPDATE phplist_user_user set email = email – 1
WHERE mail in (select mail
from drupal_users
where mail=2)

If an entry in the “mail” column from the “drupal_users” table is found then I would want it removed from the “mail” column in the “phplist_user_user” table.

What am I doing wrong?