How to write sql query to select a column with space in column name?

Question

I have a table with column like this id, email, phone, first name, last name I want to select phone corresponding to a particular email like this

Select phone from customer_tbl where email='testfinal@gmail.com';

this is working but if do something simailar for first name than it is not working, now the issue is due to space in column name.

Select first name from customer_tbl where email='testfinal@gmail.com';

It is giving below error.

Error Code: 1054. Unknown column 'first' in 'field list'

For the sake of your sanity, don't have spaces in table/column identifiers — Strawberry, Oct 27 '20 at 08:01
Make your life easier, use underscore instead of space in column names. — jarlh, Oct 27 '20 at 08:01

score 1 · Answer 1 · edited Oct 27 '20 at 08:01

1

 Select `first name` from customer_tbl where email='testfinal@gmail.com';

add the ``

edited Oct 27 '20 at 08:01

Strawberry

answered Oct 27 '20 at 08:00

Eduards

1 Answers1