How to select a column name with a space in MySQL [duplicate]

by

Generally the first step is to not do that in the first place, but if this is already done, then you need to resort to properly quoting your column names:

SELECT `Business Name` FROM annoying_table

Usually these sorts of things are created by people who have used something like Microsoft Access and always use a GUI to do their thing.

More Related Contents:

  1. get first occurrence of last changed value of a column [closed]
  2. SQL Print the name of all Employees together with the name of their supervisor
  3. MySQL – Rows to Columns
  4. ROW_NUMBER() in MySQL
  5. MySQL how to fill missing dates in range?
  6. Left Outer Join doesn’t return all rows from my left table?
  7. How can I temporarily disable a foreign key constraint in MySQL?
  8. MySQL offset infinite rows
  9. How does MySQL process ORDER BY and LIMIT in a query?
  10. Return default result for IN value regardless
  11. Generating a random & unique 8 character string using MySQL
  12. sql joins as venn diagram
  13. How can I join multiple SQL tables using the IDs?
  14. MySQL, better to insert NULL or empty string?
  15. SQL: Repeat a result row multiple times, and number the rows
  16. sql join two table
  17. Compare dates in MySQL
  18. Why do results from a SQL query not come back in the order I expect?
  19. MySQL combine two columns and add into a new column
  20. Invalid default value for ‘dateAdded’
  21. How to set a MySQL row to READ-ONLY?
  22. Split a string and loop through values in MySQL stored procedure
  23. How to create dummy variable columns for thousands of categories in Google BigQuery?
  24. how to cast the hexadecimal to varchar(datetime)?
  25. MySQL Select Query – Get only first 10 characters of a value
  26. Most efficient way to store IP Address in MySQL [duplicate]
  27. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  28. mysql select id and name from other table and join query
  29. SQL query with avg and group by
  30. Convert SQL Server query to MySQL [duplicate]

Leave a Comment