find/replace (sub)strings in zen's mysql-DB (mysql syntax question)

[mypashop]

hello, i have an issue with SQL's syntax. I am moving a DB to another server/version.

this is my SQL-query.

UPDATE `mypa_store`.`products` SET `products_model` = REPLACE(`products_model`,'376005','') WHERE `products_model` LIKE '%376005%';

I want it to "strip" (using REPLACE) '376005' in every product model
where it occurs in strings like '376005xxxxxx' . Unfortunately i cannot
figure out what to do, the query results in a "success" on "0 rows affected".

I tried hard but don't understand how the sql-manual wants me to use it.
the best, error free query i made was the one on top.


while this is more a mysql related-question, it thought it might help
some other people who need to batch-rename product models or other
strings in their zencart DB.

Anyway many thanks for the help

[DrByte]

What happens if you run this query first:

SELECT `products_model`, `products_id` FROM `mypa_store`.`products` WHERE `products_model` LIKE '%376005%';

if you get 0 records with that, then it would explain why you got 0 records with your UPDATE statement ... your WHERE clause is either incorrect or else there truly are no matching records in the database table you specified.

[mypashop]

i was trying too hard to achieve this, and after getting lots of errors and finally putting the code together, it worked, but i did´t notice it. All i saw was the 0 rows affected... At some point it worked to strip the digits, can you confirm the syntax is correct??
thanx dr byte, i queried the DB like you said and saw there were no more results... and then i saw the stripped strings. great. Many thanx.