/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 vote135 views1 answer
Run postgresql dump to csv
SQL
2 votes131 views1 answer
Oracle run_duration average
SQL
25 votes152 views4 answers
Import mysql dump command line
SQL
1 vote170 views1 answer
Oracle schema size
SQL
0 vote152 views1 answer
Show table structure mysql console
SQL
0 vote158 views1 answer
Sql select first and last record of each group
SQL
0 vote135 views1 answer
Java sql connection
SQL
1 vote131 views1 answer
Mysql check string don't have number
SQL
-1 vote125 views2 answers
Sql query examples
SQL
3 votes143 views1 answer
Locate sql server
SQL

Share