Help MySQL trouble please read.

[yozza84]

Does anyone see what wrong below? Why is it reading Pyle as the column name instead of the string? I believe the syntax is correct since i copied it from another query i have been using and just changed the columns. (And yes there is a column named 'Town' i checked that hehehehe)

 

Thank you

 

 

Error

 

SQL query: Documentation

 

SELECT Name1, Phone, Town

FROM `main`

WHERE Town = Pyle

ORDER BY Town

LIMIT 0 , 30

 

MySQL said: Documentation

#1054 - Unknown column 'Pyle' in 'where clause'

[rhodesa]

Pyle needs to be in quotes:

 

SELECT Name1, Phone, Town
FROM `main`
WHERE Town = 'Pyle'
ORDER BY Town
LIMIT 0 , 30