Jump to content



Latest News: (loading..)

- - - - -

change products names all at one time with SQL, how


This topic has been archived. This means that you cannot reply to this topic.
No replies to this topic

#-19   lsh0922

lsh0922
  • Members
  • 9 posts

Posted 31 March 2012 - 06:06 AM

i have products with the products names this way:

AAA -01
AAA -02
AAA -03
AAA -04
AAA -05
AAA -06
AAA -07
.....

AND how can i use the SQL to update the products names to below:
BBB -01
BBB -02
BBB -03
BBB -04
BBB -05
BBB -06
BBB -07
.....
can anybody tell me how to write the sql?