Sql query to get this result..

Posted by bala3569 on Stack Overflow See other posts from Stack Overflow or by bala3569
Published on 2010-04-16T04:37:08Z Indexed on 2010/04/16 4:43 UTC
Read the original article Hit count: 313

Filed under:
|
|

Consider i have a user table and i have three columns mobilePhone,homePhone and workPhone... I have to select homePhone for every user as first pref if there is no value i ll go for mobilePhone and if there is no value for it i ll go for workPhone....

Any suggestion how it can be done in mysql..

© Stack Overflow or respective owner

Related posts about mysql

Related posts about select