search

emeraldjava / bhaawp

Wordpress plugin for the Business Houses Athletic Assoication
3 stars 0 forks source link

Date Of Birth Fixes #87

Open emeraldjava opened 9 years ago

emeraldjava commented 9 years ago

SELECT * FROM wp_usermeta c1 WHERE c1.meta_key='bhaa_runner_dateofbirth' AND c1.meta_value LIKE '%00%';

emeraldjava commented 9 years ago

UPDATE wp_usermeta c1 SET c1.meta_value='1980-01-01' WHERE c1.meta_key='bhaa_runner_dateofbirth' AND c1.meta_value = '0000-00-00';