How to write a SQL query to remove html links in Magento description?

Question

I have thousands of products that include the following in the longDescription field:

<ul>
<li>Some content</li>
<li><a href="link"... </li>
</ul>

Several trailing line breaks...

I'm wondering if there is a safe and effective SQL query that can remove the <li>'s with the links in them, as well as the trailing line breaks / empty characters?

Does this have to be done in SQL? It might be easier to grab the data from the database, manipulate it in some general purpose language, then update the rows with the results. — Mark Byers
– Mark Byers, Commented Jul 12, 2012 at 21:13
You could try this solution: stackoverflow.com/questions/457701/… — scrappedcola
– scrappedcola, Commented Jul 12, 2012 at 21:14
I was thinking of doing it in ruby, as I'm no php expert, but the setup seemed longer than a quick SQL statement -- assuming someone knows one. — Nathan
– Nathan, Commented Jul 12, 2012 at 21:46

Thomas Müller · Accepted Answer · 2012-07-13 06:33:35Z

1

Best way might be to add a frontend model to the attribute. Create a model that extends Mage_Eav_Model_Entity_Attribute_Frontend_Abstract and remove the HTML in the getValue() function e.g. using strip_tags().

answered Jul 13, 2012 at 6:33

Thomas Müller

1,43311 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

How to write a SQL query to remove html links in Magento description?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related