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

either a stored procedure (assuming you are using MySQL 5 or above)

or in program logic

not possible in mysql query itself?

healdem, are you kidding? it's dead simple
cancer, this relies on "empty" being NULL, and not the empty string

and you should, of course, be using DATE datatypes, not VARCHAR

oops
misread it as a how do I update......
mea culpa