changing to nothing did not work...

Leafgreen · #1 (**permalink**) 01-05-12, 00:54

I tried to run this query, but it did not change the to a null value (in other words delete the )

Code:

UPDATE xcart_products 
   SET descr = REPLACE(descr,'</p>','')

What's wrong with the query, please?

healdem · #2 (**permalink**) 01-05-12, 03:07

becuase NULL isn't the same as ''

try

Code:

UPDATE xcart_products 
   SET descr = descr = '</p>' where descr = '' or descr is NULL;

however you may want to test the SQL does the right thing before committing such a change to actual data
so either run the update against a copy of your table or

Code:

select descr from xcart_products 
   where descr = '' or descr is NULL;

Leafgreen · #3 (**permalink**) 01-05-12, 03:13

The descr field values contain values that include . I only want to delete within the field values. So in other words:
record 1 = "aldsfj akldsjflas alksdjf aldsjf aeldfjk"
I want to change record 1 to = "aldsfj akldsjflas alksdjf aldsjf aeldfjk"

r937 · #4 (**permalink**) 01-05-12, 04:50

Quote:

Originally Posted by Leafgreen

What's wrong with the query, please?

nothing

there must be some other reason

Internet Services

Web Development

Digital Marketing

Consumer Tech