Mysql not giving Syntax error when it should

Question

I am trying with following query

SELECT COUNT(*) 
  FROM users` 
  WHERE email = '[email protected]'

This is not giving me syntax error (notice not include ` character at the starting of table name). And always gives me count as 1, although record in not there in db.

I will get the error if i remove COUNT from the query.

Hope this is not a bug in mysql.

Answer 1

The backtick seems to be commenting out the rest of the line.

I can't say why but I have tested it (through phpMyAdmin) and that it the case.