Postfix keeps saying wrong MySQL-Syntax

Question

I have the following Postfix config-file to map an email to itself (All credentials are fictional):

user = db_mailuser
password = mailuser_password
hosts = 127.0.0.1
dbname = mailserver
query = SELCET email FROM virtual_users WHERE email='%s'

When I do (after restarting postfix):

postmap -q [e-mail] mysql:/etc/postfix/mysql-email2email.cf

Then Postfix forwards the following MySQL message:

postmap: warning: mysql query failed: 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 'SELCET email FROM virtual_users WHERE email='[e-mail]'' at line 1

But at this point I am really confused, because the syntax is okay. I can go to mysql an query:

mysql> SELECT email FROM virtual_users WHERE email='[e-mail]' 

And it says:

+-------------------------+
| email                   |
+-------------------------+
| [e-mail]       |
+-------------------------+
1 row in set (0.00 sec)

What the hack could be wrong with my Postfix configuration?

Thank you in advance...

Answer 1

If this is a true copy and paste, You spelled select wrong. Its select not SELCET

DOH!!! (Been there done that)