MySQL error: Unknown column in ‘where clause’

backticks (`) are used for identifiers, like table names, column names, etc. Single quotes(‘) are used for string literals.

You want to do:

SELECT b.balance FROM bank AS b WHERE b.nick='Alex' LIMIT 1

Or, to be more explicit:

SELECT `b`.`balance` FROM `bank` AS b WHERE `b`.`nick`='Alex' LIMIT 1

When there is no chance of ambiguity, and when table/column names do not have special characters or spaces, then you can leave the ` off.

Here is some documentation that is dry and hard to read: http://dev.mysql.com/doc/refman/5.0/en/identifiers.html

But here is a related question on dba.stackoverflow that is easier to read: https://dba.stackexchange.com/questions/23129/benefits-of-using-backtick-in-mysql-queries

And here is a very good page that I recommend everyone read: http://www.sitepoint.com/forums/showthread.php?408497-the-big-bad-thread-of-quot-MySQL-Best-Practices-and-Other-Useful-Information-quot

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. Unknown column in ‘field list’ error on MySQL Update query
  3. Unknown column in ‘field list’ error on MySQL Update query
  4. How do I UPDATE from a SELECT in SQL Server?
  5. MySQL – Operand should contain 1 column(s)
  6. SQL SELECT WHERE field contains words
  7. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  8. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  9. MySQL create table if not exists and insert record only if table was created
  10. SQL SELECT WHERE field contains words
  11. How do I use properly CASE..WHEN in MySQL
  12. How can I do a FULL OUTER JOIN in MySQL?
  13. SQL SELECT WHERE field contains words
  14. MySQL query String contains
  15. What’s the difference between VARCHAR and CHAR?
  16. Case statement in MySQL
  17. How to declare a variable in MySQL?
  18. ORA-01843 not a valid month- Comparing Dates
  19. MySQL Cannot Add Foreign Key Constraint
  20. How to split the name string in mysql?
  21. How do I import an SQL file using the command line in MySQL?
  22. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  23. mysql Foreign key constraint is incorrectly formed error
  24. MySQL: Invalid use of group function
  25. How can I return pivot table output in MySQL?
  26. Compare dates in MySQL
  27. Best way to do nested case statement logic in SQL Server
  28. MySQL “WITH” clause
  29. MySQL Multiple Joins in one query?
  30. Error Code: 2013. Lost connection to MySQL server during query
  31. MySQL syntax for Join Update
  32. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  33. how to drop partition without dropping data in MySQL?
  34. MySQL combine two columns into one column
  35. Simple way to calculate median with MySQL
  36. Error 1046 No database Selected, how to resolve?
  37. MySQL Error 1264: out of range value for column
  38. Remove duplicate rows in MySQL
  39. How to SUM and SUBTRACT using SQL?
  40. Cast from VARCHAR to INT – MySQL
  41. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  42. How do you force mysql LIKE to be case sensitive?
  43. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  44. MySQL – UPDATE multiple rows with different values in one query
  45. How to create a MySQL hierarchical recursive query?
  46. ERROR 1148: The used command is not allowed with this MySQL version
  47. Insert into a MySQL table or update if exists
  48. How to round down to nearest integer in MySQL?
  49. MySQL starts with searching issue
  50. Query to convert from datetime to date mysql
  51. Is it possible to GROUP BY multiple columns using MySQL?
  52. MySQL error: key specification without a key length
  53. SQL: Two select statements in one query
  54. Best way to test if a row exists in a MySQL table
  55. SQL conditional SELECT
  56. Check if MySQL table exists without using “select from” syntax?
  57. MySQL equivalent of DECODE function in Oracle
  58. mysql update column with value from another table
  59. The used SELECT statements have a different number of columns
  60. How to delete from multiple tables in MySQL?
  61. MySQL: Can’t create table (errno: 150)
  62. How to copy a row and insert in same table with a autoincrement field in MySQL?
  63. Join vs. sub-query
  64. Alternative to except in MySQL
  65. DATEDIFF function in Oracle
  66. Equivalent of explode() to work with strings in MySQL
  67. ROW_NUMBER() in MySQ
  68. MySQL OPTIMIZE all tables?
  69. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  70. MySQL – Get row number on select
  71. Postgresql column reference “id” is ambiguous
  72. How to truncate the text returned for a column in a MySQL query
  73. How to order by column A and then by column B?
  74. Using union and order by clause in mysql
  75. MySQL LIKE IN()?
  76. Help me SELECT thumbnail from SQL and use
  77. Database SQL query error
  78. how to SELECT meta values that are not null?
  79. Conversion failed when converting date and/or time from character string while inserting datetime
  80. error, string or binary data would be truncated when trying to insert
  81. Why do we need “Relationships” between tables at all?
  82. How do I escape a single quote in SQL Server?
  83. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  84. MySQL SELECT increment counter
  85. How to join two tables by multiple columns in SQL?
  86. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  87. I want to use CASE statement to update some records in sql server 2005
  88. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
  89. How to query MongoDB with “like”
  90. Error converting data type varchar
  91. I want to use CASE statement to update some records in sql server 2005
  92. Is merge statement available in MySQL
  93. Filter data based on date in sql
  94. How to remove in the wordpress database all posts revisions except the last three?
  95. Query WordPress database by registered date and role
  96. Why this query is not showing any result on wordpresss home page?
  97. making php value numeric
  98. post id not displaying
  99. Unknown column ‘wp_posts.ID’ in ‘field list
  100. Improving performance of SQL sub-queries in WordPress

Leave a Comment