SQLTeam.com | Weblogs | Forums

How choose item name include 'and'


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.


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


Thank you. It works