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

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".

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

What happens if you run this query first:```
SELECT products_model, products_id FROM mypa_store.products WHERE products_model LIKE '%376005%';

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??
:clap: 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.