SQL Query help

[DAMINK]

Thankyou for the reply Lynne.
Im sorry about the lack of information.
The error i receive is as below. This error is at the top of the page when loading there profiles.

Warning: mktime() expects parameter 4 to be long, string given in [path]/includes/class_userprofile.php on line 260

The user in question has a DOB of January 1 (2012) visible in his profile however the database shows -- in the DOB row. As image below.



So would it be something like this?


UPDATE user
SET birthday = '' , birthday_search='1970-01-01'
WHERE birthday = ==

Or would it be like below

UPDATE user
SET birthday = '' , birthday_search='1970-01-01'
WHERE birthday = 2012-01-01

lol i really have no idea to be honest.

--------------- Added [DATE]1330222800[/DATE] at [TIME]1330222800[/TIME] ---------------

Update. I got it to work... Not sure if it was the correct way or anything lol but did this.

UPDATE user
SET birthday = '' , birthday='1970-01-01'
WHERE birthday = '--'

Now everyone that had no birthday atleast has one.
Not an ideal fix but works for me none the less.
Thanks again Lynne.