Using preg_replace in mysql

Question

I have a CMS content in database. The content contains '<img src= .............../>' also. I want to retrieve this content using mysql query and show on frontend but with all '<img src='.........../>' removed from the content.

How can it be done using query in mysql?

Why not do this in PHP after you retrieve your content from database? — Young, Commented Mar 24, 2010 at 6:57
Why don't you remove it in PHP? Preferably prior insertion to DB if you will always remove them before displaying. — reko_t, Commented Mar 24, 2010 at 7:10

Ignacio Vazquez-Abrams · Accepted Answer · 2010-03-24 06:50:27Z

1

Once you install lib_mysqludf_preg you'll be able to use various regex functions in MySQL. See the docs on that page to find out more about them.

DISCLAIMER: I have not used this package and will not guarantee that it won't do anything to the server.

answered Mar 24, 2010 at 6:50

Ignacio Vazquez-Abrams

801k160 gold badges1.4k silver badges1.4k bronze badges

Add a comment |

Collectives™ on Stack Overflow

Using preg_replace in mysql

1 Answer 1

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Linked

Related