/SQL/Mysql check if null or empty string

Mysql check if null or empty string

Check if value is null mysql

SELECT * from TABLE where CODE IS NULL OR CODE!='C'

4

Source: stackoverflow.com

How to check a db specific rows col is empty

SELECT * FROM table WHERE some_col IS NULL OR some_col = '';

1

Source: stackoverflow.com

Mysql check if null or empty string

SELECT 
    id, 
    user_id, 
    charge,
    IF(status IS NULL or status = '', 'PENDING', status) as status 
FROM `user_payments`

0

Source: nicesnippets.com

Similar codes

2 votes194 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
3 votes191 views1 answer
Oracle APEX elapsed time
SQL
1 vote183 views3 answers
Rename table snowflake
SQL
6 votes200 views3 answers
Sql select last id
SQL
0 vote176 views1 answer
Deny select insert update delete sql
SQL
5 votes228 views2 answers
Create table mysql example auto_increment
SQL
0 vote198 views1 answer
How to get one year old query from plan cache
SQL
1 vote281 views1 answer
Show databases mysql docker
SQL
0 vote178 views1 answer
Knex last insert id mysql
SQL
-1 vote284 views5 answers
Left join
SQL

Share