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
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!
