NCR2000 Posted October 23, 2005 Share Posted October 23, 2005 Need help building a sql query which needs to be ran to do the follow Set price_prefix to "+" in products_attributes table on all entries Can anyone help me? Link to comment Share on other sites More sharing options...
Guest Posted October 23, 2005 Share Posted October 23, 2005 update products_attributes set price_prefix = '+' backup your dbase first. Link to comment Share on other sites More sharing options...
stevel Posted October 23, 2005 Share Posted October 23, 2005 update product_attributes set price_prefix = '+' Edit: too slow Steve Contributions: Country-State Selector Login Page a la Amazon Protection of Configuration Updated spiders.txt Embed Links with SID in Description Link to comment Share on other sites More sharing options...
NCR2000 Posted October 23, 2005 Author Share Posted October 23, 2005 Need help building a sql query which needs to be ran to do the follow Set price_prefix to "+" in products_attributes table on all entries Can anyone help me? Got it UPDATE `products_attributes` SET `price_prefix` = '+' WHERE `price_prefix` ='-'; then ran UPDATE `products_attributes` SET `price_prefix` = '+' WHERE `price_prefix` =''; to get all price_prefix set to + Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.