Show the content of table with column that includes spaces

Hi All

I am trying to run the following query in MYSQL

SELECT 'Statutory Highest Age' FROM schools.edubase_schools_july_2017;

all it shows is the following

Statutory Highest Age - Column Name

‘Statutory Highest Age’ - Rows
‘Statutory Highest Age’
‘Statutory Highest Age’
‘Statutory Highest Age’
‘Statutory Highest Age’

is there a way I can get the content to show other than ‘Statutory Highest Age’ the data I am looking for consists of numbers

Simple fix = You need to add back ticks inseatd of using ’ ’

SELECT `Statutory Highest Age` FROM schools.edubase_schools_july_2017;
1 Like

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.