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: 315
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