Sql query to get this result..
- by bala3569
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..