Hi,

I want to delete some info from my products table from my database...Here's what I have so far:

UPDATE products SET description=REPLACE(description, 'oldstring', 'newstring');

Now, let's say I only want to delete only the text that was linked in the description field? How would I achieve that?

Thank you!
-Brian

Have just tried this and still no good:

UPDATE tablename SET fieldname=REPLACE(fieldname, REGEXP ''^<a>.</a>$",'');

Any ideas?

Hi,

^^ Just curious if anyone could figure out the code in my previous post...^^

I was trying to delete links from descriptions from an sql (MYSQL) database.

Ex:

This is my description, and This is an Example of what I am trying to delete from an sql query using phpmyadmin</a>

The code in the previous post didn't work, can anyone assist?

-Brian