mysql Start with a specific word and search with initial consonants

Hi, everyone. You want to find data from specific words to initial z. I searched for regular expressions, but I don't know how to do it, so I'm asking you this question.

I've looked for these methods

select * from (table) where (col) regexp '^[a-z]';

What he wants is Col = If it's 'appl'

I want to search for data from apple to initial consonant z.