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"
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.
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Unsolved 
