A code is worth a thousand words

MySQL - Get first letters

You are here

This snippet shows you how to select discinct first letters of titles. After getting the first letters you might want to transliterate the characters, you can do it in mysql by custom function where it's done by string replace.