mysql - Select a column with a keyword name

Question

I have a table named 'test'

It contains a column named 'AND'

For that I use the following queries

insert into test values ('a','abc');
insert into test values ('b','def');

Now I want to select my 'AND' column from the 'test' table

The query select AND from test; wont work because AND is keyword

I tried

select "AND" from test;
select 'AND' from test;

Both queries return the wrong results as show below

How can I select my 'AND' column?

Answer 1

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;