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?

A bonus question... funny :) Is there also a bonus award? ;) — Felix Kling
– Felix Kling, Commented Mar 29, 2010 at 18:47
@Felix: yes, the OP will get friends to join SO and upvote too. — Cascabel
– Cascabel, Commented Mar 29, 2010 at 18:51

Fırat Küçük · Accepted Answer · 2010-03-29 18:52:00Z

3

try this:

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

answered Mar 29, 2010 at 18:52

Fırat Küçük

6,0832 gold badges55 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Frank Nwoko · Accepted Answer · 2011-01-04 21:45:22Z

0

answered Jan 4, 2011 at 21:45

Frank Nwoko

3,9145 gold badges27 silver badges33 bronze badges