mysql « regex « HTML CSS Q&A

1. Remove text from within a database text field    stackoverflow.com

I recently tried to import a bunch of blog posts from an old blog (SharePoint) to my current blog (WordPress). When the import completed, a lot of nasty <div> tags ...

2. Regex for mysql query to match html entities    stackoverflow.com

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 ...

3. MySQL search for text in html text field?    stackoverflow.com

There is a CKEditor field on our website which saves it's HTML to a text field in a MySQL database. What I'm wondering is, if there is a function (regex ...

4. Regexp matching for text outside html tags in MySQL    stackoverflow.com

I have a sql query in MySQL and I want an expression that matches with the string not between '<' and '>'. For example:

select '<span class="boldtext">collaboratively site</span> – regardless of platform ...

5. Search to exclude html tags in MySQL    stackoverflow.com

I need a search query which will exclude text within HTML tags. For example, I need to search for a word called "spa" in my database. There are HTML tags in ...