mySQL - if...else condition help....

cancer10's Avatar, Join Date: Jul 2008
Go4Expert Member
Hi there,


I have a table - mytable and the columns in the table are as follows:


CityName (varchar)
updated_by (varchar)
added_by (varchar)

The first column is a city column, someone would add/update the city names and accordingly their name would be updated/added to the updated_by and added_by columns. Now, the condition of my query would be:

- if the updated_by column is NOT empty and the added_by column is empty, then the value of the updated_by would show .

- if the added_by column is NOT empty and the updated_by column is empty, then the value of the added_by column would show.

- if both added_by and updated_by columns are NOT empty then the value of the updated_by would show.



Could this be done in one single query? If yes, how (example plz)?


Thanx in advance
0
pradeep's Avatar, Join Date: Apr 2005
Team Leader
Code:
IF(added_by IS NULL AND updated_by IS NOT NULL,updated_by,added)
I wrote a part, you can write whatever condition you want this way!