Filtering problem


#1

How do I find all artists whose name contains "And"?
For example:
Al Bano And Romina Power
Billy Vaughn And his Orch
Candy Dulfer And Dave Stewart


#2

artist HAS and


#3

and find all artists whose name is the letter combination "and":
Sandra, Jan Holland, The Big Apple Band, Michel Legrand, ...
But I need only the word "and"!


#4

artist HAS " and "


#5

Thanks