MySQL

run an query

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Oct 2006

Posts: 75

Reputation: welbyobeng is an unknown quantity at this point

Solved Threads: 0

welbyobeng welbyobeng is offline

Offline

Junior Poster in Training

run an query

Dec 20th, 2008

I have a table called "users", in the table it contain a column/ field name "reg_date" how would i run an query to say: For all the users, if their feild "reg_date" is blank put "20th December 2008"

•

Join Date: Dec 2008

Posts: 20

Reputation: manish.s is an unknown quantity at this point

Solved Threads: 1

manish.s

Offline

Newbie Poster

Re: run an query

Dec 21st, 2008

please let me know the data type of field "reg_date".

•

Join Date: Oct 2006

Posts: 75

Reputation: welbyobeng is an unknown quantity at this point

Solved Threads: 0

welbyobeng welbyobeng is offline

Offline

Junior Poster in Training

Re: run an query

Dec 21st, 2008

varchar(32)

•

Join Date: Dec 2008

Posts: 20

Reputation: manish.s is an unknown quantity at this point

Solved Threads: 1

manish.s

Offline

Newbie Poster

Re: run an query

Dec 21st, 2008

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT user_id,user_name,if(reg_date="","20th December 2008",reg_date) as 'Reg. Date' FROM users
 
WHERE  user_id = UNIQUE User ID
           user_name = Store User Name
select user_id,user_name,if(reg_date="","20th December 2008",reg_date) as 'Reg. Date' from users

where  user_id = Unique User ID
           user_name = Store User Name

Last edited by peter_budo; Dec 21st, 2008 at 5:14 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.