Regex for mysql query to match html entities.

Question

I understand PCRE pretty well, but MySQL's regular expression flavor seems to get the best of me.

Can someone help me correct this expression? The PCRE equivalent would be &\w+;

I'm guessing something like:

select body from email where body rlike '&[[:alpha:]]+;%'

Bonus:

MySQL's docs on their regex flavor seem kinda sparse. Does anyone have a good resource specifically geared toward mysql regex they can point me to?

Answer 1

try this:

select body from email where body REGEXP '\&[a-z0-9A-Z]+\;'