Coalesce mysql

Mysql coalesce

#Avoid sum null
SELECT SUM(COALESCE(field_with_null_values, 0)) as s FROM tablename

#Avoid concat string null
SELECT CONCAT(name_never_null, ' ', COALESCE(surname_with_null_values, '')) as complete_name FROM users

Source: grepper.com

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

Source: grepper.com

Similar codes

52 votes430 views6 answers
Rename column sql
SQL
1 vote245 views1 answer
Oracle update with sequence
SQL
0 vote255 views1 answer
Get record which is available in one table but not in another mysql
SQL
1 vote252 views1 answer
Postgres get month name from date
SQL
1 vote238 views1 answer
Mysql select month and year
SQL
0 vote281 views1 answer
Sql column contains special character
SQL
0 vote255 views1 answer
Sql contains vs like
SQL
0 vote258 views1 answer
Oracle query archivemode
SQL
0 vote236 views1 answer
Wordpress sql find and replace
SQL
0 vote269 views1 answer
Execute sql stored procedure in powershell
SQL