1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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

Discussion in 'MySQL' started by cancer10, Aug 18, 2008.

  1. cancer10

    cancer10 New 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
     
  2. pradeep

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

Share This Page