python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - concat-ws

mysql - Query with IFNULL and CONCAT_WS returns empty string instead predefined IFNULL parameter in case of NULL

I am working on the complex MySQL query with subquery and JOINs and this is my query: SELECT id, ancient_source_name, ancient_source_name_alt, ancient_source_type, ancient_source_t...
test-img

Boris J.

mysql

if-statement

subquery

ifnull

concat-ws

Votes: 0

Answers: 1

Latest Answer

CONCAT_WS() returns an empty string if all arguments after a non-null separator are NULL. See the demo. I did not find this stated explicitly in MySql's documentation (like it is made clear in SQL Ser...
test-img

forpas

Posts

Questions

Blogs

Jobs