Is there any way to COUNT regexp matches in MySQL and store it in a column in the results set?

e.g.,

SELECT name, COUNT(REGEXP '[ae]') as matches FROM table
If so, could you provide a couple of examples? I need to do something like this for sorting purposes.