Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

MySQL COALESCE() Function

Concept visual

MySQL COALESCE() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Formula

Return the first non - null value in a list:

Select

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

Definition and Usage

Formula

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

Syntax

Coalesce(

val1, val2,...., val_n )

Parameter Values

Parameter

Description val1, val2, val_n Required. The values to test

Technical Details

Works in:

From MySQL 4.0

More Examples

Example

Formula

Return the first non - null value in a list:

Select

COALESCE(NULL, 1, 2, 'W3Schools.com');

MySQL COALESCE() Function

Concept visual

MySQL COALESCE() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Formula

Return the first non - null value in a list:

Select

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

Definition and Usage

Formula

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

Syntax

Coalesce(

val1, val2,...., val_n )

Parameter Values

Parameter

Description val1, val2, val_n Required. The values to test

Technical Details

Works in:

From MySQL 4.0

More Examples

Example

Formula

Return the first non - null value in a list:

Select

COALESCE(NULL, 1, 2, 'W3Schools.com');

MySQL COALESCE() Function

MySQL COALESCE() Function

Example

Select

Definition and Usage

Syntax

Coalesce(

Parameter Values

Parameter

Technical Details

Works in:

More Examples

Example

Select

Previous

Next

MySQL COALESCE() Function

MySQL COALESCE() Function

Example

Select

Definition and Usage

Syntax

Coalesce(

Parameter Values

Parameter

Technical Details

Works in:

More Examples

Example

Select

Previous

Next