SELECT Name FROM ARTIST WHERE Name LIKE "%a%"
Find the names of all artists that have "a" in their names.
SELECT Name FROM ARTIST WHERE Name LIKE `` % a % ''
select name from artist where name like value
Find the names of all artists that have `` a '' in their names .