How choose item name include 'and'

1

I wanna select items such as structure like "A and B", so I use query

select table.column_1 from table
where table.column_1 like "%and%"

The problem is this query not only returns all the items like "A and B", but also has name Andrea, Anderson, England, etc. How can I kick off all the things I don't need.

2

like "% and %"
Notis the space around the word.

3

Thank you. It works