Select a column with a keyword name

by

use backtick to escape keyword instead. just like how you created your table. using double quote or single quote will parse it into string that is why you’re getting two records of and

select `AND` from test;

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. MySQL pivot row into dynamic number of columns
  3. Rank function in MySQL
  4. Count the number of occurrences of a string in a VARCHAR field?
  5. Find nearest latitude/longitude with an SQL query
  6. MySQL – Operand should contain 1 column(s)
  7. How to get the difference in years from two different dates?
  8. Restore table structure from frm and ibd files
  9. mysql pivot/crosstab query
  10. MySQL: Split comma separated list into multiple rows
  11. Most efficient way to get table row count
  12. UNION query with codeigniter’s active record pattern
  13. Subqueries with EXISTS vs IN – MySQL
  14. Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?
  15. Remove Primary Key in MySQL
  16. 60 million entries, select entries from a certain month. How to optimize database?
  17. Get most recent row for given ID
  18. Is it possible to GROUP BY multiple columns using MySQL?
  19. MySQL monthly Sale of last 12 months including months with no Sale
  20. Is merge statement available in MySQL
  21. Mysql covering vs composite vs column index
  22. MYSQL syntax not evaluating not equal to in presence of NULL
  23. MySQL: LAST_INSERT_ID() returns 0
  24. Using reserved words in column names
  25. MySQL INNER JOIN select only one row from second table
  26. Storing IPv6 Addresses in MySQL
  27. Insert/ Update random date in MySQL
  28. Replace null with 0 in MySQL
  29. Get total hours worked in a day mysql
  30. ORDER BY alphabet first then follow by number

Leave a Comment