mysql statement help

teclance · 12-14-2005, 10:07 AM

Hey,

I am running OSC and I need to issue a MYSQl statement to the effect of:

products_model = products_id ONLY if the products_model field is blank.

In other words, if there is ALREADY a product model, it should be left alone. If there is NOT one already then it should be set to the products_id.

Does any one have a suggestion of how to do this?

thanks a bunch

sjp · 12-14-2005, 10:11 AM

update table_name set products_model = products_id where products_model is null

or depending on what you consider blank

update table_name set products_model = products_id where products_model = ''

teclance · 12-14-2005, 10:22 AM

thanks a bunch for that I will give it a shot.

12-14-2005, 10:07 AM	#1 (permalink)
teclance NamePros Regular Join Date: Feb 2004 Posts: 631 57.15 NP$ (Donate)	mysql statement help Hey, I am running OSC and I need to issue a MYSQl statement to the effect of: products_model = products_id ONLY if the products_model field is blank. In other words, if there is ALREADY a product model, it should be left alone. If there is NOT one already then it should be set to the products_id. Does any one have a suggestion of how to do this? thanks a bunch __________________ Sincerely Mike Kelly

12-14-2005, 10:11 AM	#2 (permalink)
sjp NamePros Member Join Date: Oct 2005 Location: Andromeda Posts: 136 369.50 NP$ (Donate)	update table_name set products_model = products_id where products_model is null or depending on what you consider blank update table_name set products_model = products_id where products_model = '' __________________ Christmas FAQ \| Hussein Trial Blog \| News for developers \| Find your IP address \| Anti-Spyware resource \| The Interweb \| Halloween FAQ \| sweetgifts.us \| lqfp.com

12-14-2005, 10:22 AM	#3 (permalink)
teclance NamePros Regular Join Date: Feb 2004 Posts: 631 57.15 NP$ (Donate)	thanks a bunch for that I will give it a shot. __________________ Sincerely Mike Kelly

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HOWTO: Install the Apache Web Server, Perl, PHP, and MySQL on Windows	deadserious	Webmaster Tutorials	96	05-27-2007 01:24 PM
Great Scripts for Sale With Resale Rights!	Zeeble	Scripts For Sale	20	01-04-2006 01:39 AM
MySQL Tips	shahid_146	Webmaster Tutorials	4	10-18-2005 12:53 PM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 09:46 PM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 01:17 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)