[SOLVED] unknown column in where clause

[blunerve09]

I'm using the below statement to search the database for a specific city. The same exact statement works when I search the database for the zip code.

 

SELECT name, email FROM table WHERE city LIKE leesburg

 

Every time I run this query, I get an error that says:

 

Unknown column 'leesburg' in 'where clause'

 

Any ideas?

[isaac_cm]

maybe because zip code is a numeric field and city is a varchar field so you better use "" like this

 

SELECT name, email FROM table WHERE city LIKE "leesburg"

[Wildbug]

Issac's right; "leesburg" is a string, not a number.

 

Also, if you're not using any wildcards with LIKE, why not use equals (=) for reasons of efficiency?

[blunerve09]

thanks, that made it work. I appreciate your help