This is a dumb question but I'm trying to add a products manufacturer name to the end all the products.
For example if the product is "Blue earrings" and the manufacterer's names is "Tim's Gemstones" then I would like to switch the name of that product to "Blue Earrings - Tim's Gemstones". For seo purposes.
Can someone help me with the sql for this please. I have access to my database but can't figure out the correct syntax.
Here is basically what I'm trying to do
Set zen_products_description.products_name Where zen_products.manufacturers_id = 5 zen_products_description.products_name+zen_products.manufacturers_id
thank you
Bookmarks