• My Errors
  • Login
  • Search
Search again

Error #67051

Unknown column 'blah' in 'where clause'

User's solution

This works!
+0 Vote Up

I was using a MySQL alias named blah and for some reason it wasn't properly recognizing it in the WHERE clause. I changed the syntax of the SQL statement to exclude the blah field from the SELECT ___ section and used direct access to the function I wanted in the where statement. This won't make much sense, I bet.

Dec 03, 2007

Comments

blah isn't the ideal name for a MySQL table. Not very descriptive. Some tables and column naming conventions: http://homepage.mac.com/k...index.html

Matthew Apr 19, 2008