SQLite Forum

Delete duplicate rows with an extra character
Login
Note that you will need to do `pragma case_sensitive_like=1;` to use the unique index on player_tag (unless, of course, player_tag is case insensitive) ...