artist like "* word *" or artist like "word *" or artist like "* word"

Note the spaces. Also note that this isn't perfect, because it doesn't cope with punctuation. You can add clauses to cope with that, but it'll get more and more unwieldy.