Mysql coalesce

Coalesce mysql

The COALESCE() function returns the first non-null value in a list.

Example : SELECT COALESCE(NULL, NULL, 'W3Schools.com', NULL, 'Example.com');

output : 'W3Schools.com'

-1

Similar codes

27 votes221 views5 answers
Mysql set password for user
SQL
0 vote152 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote176 views1 answer
Forcefully delete a row in mysql which has references
SQL
0 vote268 views1 answer
Mysql select random rows large table
SQL
0 vote216 views2 answers
Sql update multiple tables
SQL
0 vote205 views1 answer
Remove mysql from centos 7
SQL
0 vote172 views1 answer
Get records in sql according to month name and count
SQL
0 vote206 views1 answer
Pgadmin save data greyed out
SQL
1 vote194 views1 answer
Trim leading zeros in sql
SQL
1 vote193 views1 answer
Oracle turn off constraint
SQL