Forum SQL Query conditional for Birthdays
 

I'd like to modify all my user accounts profile display so that

if "Hide Age and Date of birth" is selected it remains selected
but
if "Display age and full date of birth" is selected, the query will change this to "Display only day and month of birth"

I have no idea how to do this conditionally

UPDATE vb_user SET showbirthday = xxx


Hide Age and Date of birth
Display only age
Display only day and month of birth
Display age and full date of birth

It is really important that the people who have selected hide age and date of birth remain in that state. Maybe I could do this by making new usergroups and process by usergroup then move them all back to their current groups.


While were in SQL queries mode is there a simple query that would make all signature text [i] italic?
My boards signatures do not stand out well as signatures. In a lot of cases they look like part of the posts.