What is a SQL command to change products_model ?

[sportbiker]

I know this is wrong and the syntax isn't right, but I'm trying to find the proper sql syntax to change a product model number. We have to update a bunch of numbers and using the SQL command will go a lot easier than using the admin panel.

I was playing with this, but I know it's just not right:

UPDATE products SET products_model = '123-NEW' WHERE products_model = '123-OLD'

Many thanks in advance

[Ajeh]

I am not sure where this would be wrong, but if you want to run it from the Install SQL Patches ... you should use:

UPDATE products SET products_model = '123-NEW' WHERE products_model = '123-OLD';

And all Products with the products_model of 123-OLD will be changed to 123-NEW ...

[sportbiker]

Ajeh, thank you! That's it!
I was only guessing at my own code.
I can't believe I was that close!
It worked! Thanks again!

[Ajeh]

You are most welcome ... glad to be able to help you out ...

You were exactly right with your SQL and could have gotten away with it, as is, in phpMyAdmin, but in the Install SQL Patches it requires the semi-colon om the end of each line and a few other rules to follow ...