/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

0 vote242 views1 answer
Duplicate foreign key constraint name
SQL
2 votes268 views1 answer
Oracle sql concatenate results into string
SQL
0 vote264 views1 answer
Criteria builder select subset of column
SQL
4 votes279 views3 answers
Rename table column postgresql
SQL
0 vote293 views1 answer
Postgres list users and roles
SQL
1 vote256 views1 answer
How to see all table partition in oracle
SQL
0 vote267 views1 answer
Postgresql default value boolean
SQL
0 vote258 views1 answer
Select row from mysql where date more than 30 days
SQL
12 votes282 views2 answers
Find duplicates mysql column
SQL
8 votes232 views1 answer
Similarities between ddl and dml
SQL

Share