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