New answers tagged mysql
1
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:
SELECT *
FROM `#__artists`
WHERE `artist` LIKE "...
Top 50 recent answers are included
