Regex in query instead of PHP?

[blobaugh]

Jay! This is awesome!

It looks like right now all the posts are being pulled out and parsed via PHP. You may be able to get performance improvements querying MySQL directly and ditching the PHP layer. What do you think of trying out a direct regex on the db with something like https://dev.mysql.com/doc/refman/8.0/en/regexp.html ?

[JayWood]

@blobaugh I honestly had the same thought, I just haven't messed with SQL regex like, ever. I wouldn't mind a PR 😄

I wonder the performance implications from using pure SQL?