I have a table - mytable and the columns in the table are as follows:
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