MySQL search and replace regex

Question

I'd like to remove the <ul> and <li> tags without hurting the inside tags for all occurrances of this kind of structure:

<ul class="listapdf">
<li><a href="something">something</a></li>
<li><a href="something">something</a></li>
</ul>

What command can I use in MySQL command line?

Perhaps, you should check this page: http://stackoverflow.com/questions/986826/how-to-do-a-regular-expression-replace-in-mysql — Wiktor Stribiżew, Apr 12 '15 at 21:41
**Don't** process xml/html/... with regexes, use tools like **xpath**... — Willem Van Onsem, Apr 12 '15 at 21:46
How is this stored in MySQL? You just have raw html in your database? — Devon Bessemer, Apr 12 '15 at 22:13
@Davon: is a Wordpress database. They are inside the post contents table. — MultiformeIngegno, Apr 13 '15 at 13:21

score 0 · Answer 1 · answered Apr 13 '15 at 03:51

0

MySQL's REGEXPs can locate rows, it cannot do substitutions. Do the processing into your client code.

answered Apr 13 '15 at 03:51

Rick James

1 Answers1