cavinz

MySql : To get first not null value in select query

If we want to get first not null value we have function in mysql to get this result COALESCE Example : TABLE STRUCTURE ——————————————– | id | customername | mobile | home | work | ——————————————– | 1 | Joe | 123 | 456 | 789 | ——————————————– | 2...Read more …