MySQL If Statement With IS NULL Example

MySQL

Nicesnippets

08-01-2022


Hello Friends,

This article will give you example of MySQL if statement with is null. I explained simply about MySQL if statement with is null. This tutorial will give you simply example of MySQL if statement with is null.

In this post, You'll learn use how to use if statement with is null in MySQL. i will show you use of if statement with is null in SQL query.

Here i will give you many example for MySQL if statement with is null.

Table: users_payment


So, let's see bellow solution:

Solution SQL Query:

SELECT

id,

user_id,

CASE WHEN charge IS NULL

THEN 0

ELSE charge

END as charge,

payment_date

FROM `user_payments`

Output:

It will help you...


Recommended Posts