Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MySQL (http://www.go4expert.com/forums/mysql-forum/)
-   -   mySQL - if...else condition help.... (http://www.go4expert.com/forums/mysql-ifelse-condition-help-t13030/)

cancer10 18Aug2008 22:05

mySQL - if...else condition help....
 
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

pradeep 3Oct2008 13:38

Re: mySQL - if...else condition help....
 
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!


All times are GMT +5.5. The time now is 21:08.