I need to create an SQL query where it will batch rename a field if the product is in a certain category.
I've already got the update script to work, but now I need to add a "where" statement so that it will only update if the product is in a defined list of categories.
Thread: Need help creating SQL query...
Results 1 to 3 of 3
-
21 Jun 2011, 01:20 PM #1
Totally Zenned
- Join Date
- Mar 2009
- Posts
- 609
- Plugin Contributions
- 0
Need help creating SQL query...
-
22 Jun 2011, 01:13 PM #2
Totally Zenned
- Join Date
- Mar 2009
- Posts
- 609
- Plugin Contributions
- 0
Re: Need help creating SQL query...
Can anyone help at all, I have about 1000 products that need a word replacing in a certain set of categories, can anyone help automate this for me?
-
22 Jun 2011, 02:05 PM #3
Totally Zenned
- Join Date
- Jun 2008
- Location
- Washington, DC
- Posts
- 789
- Plugin Contributions
- 7
Re: Need help creating SQL query...
Post the script you have and maybe we can add the where?I've already got the update script to work, but now I need to add a "where" statement so that it will only update if the product is in a defined list of categories.
Skip• 446F63746F722057686F •
Reply With Quote
Similar Threads
-
v154 Help with a SQL Query for Query Builder
By lindasdd in forum Managing Customers and OrdersReplies: 2Last Post: 24 Mar 2016, 01:18 PM -
v151 Need some help building a looping SQL query to fill an array.
By Chris Stackhouse in forum General QuestionsReplies: 2Last Post: 3 Sep 2015, 08:19 PM -
v150 Need an uninstall SQL query
By coucho in forum All Other Contributions/AddonsReplies: 8Last Post: 12 Dec 2012, 07:16 AM -
Need help with SQL query. Want to make membership that expires.
By TecBrat in forum Managing Customers and OrdersReplies: 1Last Post: 18 Jun 2010, 03:43 PM -
Need help w/ SQL query in phpMyAdmin
By audradh in forum General QuestionsReplies: 17Last Post: 16 Nov 2009, 01:05 PM
