查询列名为空格的表？

Question

I am currently trying to get table data that have column names with spaces.

The client has created the database with column names having spaces, the table is joined across other tables, I have tried using the column name in [] and '' but don't seem to work. My query is as follows:

$query = "SELECT appliances.*, location.* FROM (appliances LEFT JOIN location ON appliances.Location ID = location.ID) WHERE Location ID = 11";

Answer 1

"I asked the client to change the column to have an underscore but this column is linked across many tables in there database."

Since the column name cannot be changed as outlined in comments, give this a try.

appliances.`Location ID` = location.ID) WHERE `Location ID`

or

`appliances`.`Location ID` = location.ID) WHERE `Location ID`

• Notice those are ticks and not regular single quotes.

Check for errors also. I do not know which API is being used to connect with, nor on which platform.

• This (example) answer is based on MySQL and not MSSQL, since the question was tagged as mysql.