Ok, so queries are not my bag baby
I need to know how to properly write an SQL Update query please. I have a table called zen_products_description and one of my categories is Bible covers. I want to do the following:
There are some Bible covers that contain Bible Cases open flat and feature in the description. I need to write an update query that says where the description contains Bible Cases open flat and feature, blank it out to say nothing. Does this make sense?
tia...
0be1
P.S. Here is what I tried - UPDATE zen_products_description SET products_description = ' ' WHERE products_description = 'Bible Cases open flat and feature'
Thread: Basic SQL Update command
Results 1 to 1 of 1
-
29 Jul 2008, 02:00 PM #1
Totally Zenned
- Join Date
- Sep 2004
- Location
- Murfreesboro, TN
- Posts
- 588
- Plugin Contributions
- 0
Basic SQL Update command
"Give me one hundred preachers who fear nothing but sin and desire nothing but God, and I care not whether they be clergymen or laymen, they alone will shake the gates of Hell and set up the kingdom of Heaven upon Earth." - John Wesley
Similar Threads
-
v139h What is a SQL command to change products_model ?
By sportbiker in forum Setting Up Categories, Products, AttributesReplies: 3Last Post: 4 Nov 2013, 10:01 PM -
SQL command to update order status ?
By Akasashasha in forum General QuestionsReplies: 2Last Post: 4 Mar 2011, 10:02 AM -
metatags_title_status - sql command?
By Kenichi in forum General QuestionsReplies: 2Last Post: 20 Jan 2011, 10:15 PM -
SQL command to update category images?
By Jeff G in forum Setting Up Categories, Products, AttributesReplies: 0Last Post: 2 Dec 2009, 10:53 PM -
SQl Command to update all prices in bulk
By ksmglobal in forum Setting Up Categories, Products, AttributesReplies: 2Last Post: 3 Apr 2008, 03:34 PM
Bookmarks