MySQL's different quote marks

Question

I am a bit new to MySQL and just wanted to know what is the difference between:

`   '    "

when I'm using them in a query.

Answer 1

With ` you write mysql variable names. With ' you write mysql variable values

For example

SELECT * FROM `test` WHERE `x` = '1'

Answer 2

I would add that the way double quotes are interpreted depend of wether or not your MySQL server has ANSI quotes turned on or off.

In the former you cannot use double quotes as a string delimiter.

SELECT name FROM user WHERE last_name = "norris" ;

will return you a punch in your teeth.