What is the error in this SQL query?

Question

I have a problem when I execute this query:

SELECT 'preg', 'respA', 'respB', 'respC', 'respD', 'respV', 'subTema' 
FROM comun 
WHERE 'id' = 3

In the table id is of type INT.

PHPMyAdmin says that the query is correct but returns 0 rows and the table has 4 rows. What is the error?

Thank you very much!

Did you just call a query a "consultation"? – nzifnab Aug 01 '14 at 16:20 — nzifnab, Aug 01 '14 at 16:20
remove quotes, or use back ticks for field names – bansi Aug 01 '14 at 16:21 — bansi, Aug 01 '14 at 16:21
the problem was 'id'=3 if i write id = 3 it works – wiki Aug 01 '14 at 16:22 — wiki, Aug 01 '14 at 16:22

score 2 · Answer 1 · answered Aug 01 '14 at 16:20

Use backticks to escape column and table names, not quotes.

SELECT `preg`, ...
FROM `comun` 
WHERE `id` = 3

Quotes indicate a static string. And it returns zero rows because the static string id is not equal to 3.

But actually you only need to escape reserved words in MySQL.

1 Answers1