Method 1 - Store additional column
First method is to store additional column in your artists table with only a latin characters in it (eg. beyonce).
Method 2 - Update the LIKE query
MySQL have the ability to replace exacly one character with a wildcard. In your case the query would look like this:
WHERE `artist` LIKE "...