SQLTeam.com | Weblogs | Forums

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