/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

1 vote160 views1 answer
Sql myisam vs innodb
SQL
11 votes188 views1 answer
Oracle view source
SQL
0 vote189 views1 answer
Check user sql password from command line
SQL
0 vote206 views1 answer
How to join result table in mysql
SQL
0 vote137 views1 answer
Calculate discount from original price sql
SQL
0 vote607 views1 answer
Mysql custom sort order
SQL
2 votes213 views2 answers
Mysql does sentence contain word
SQL
0 vote189 views1 answer
Groupby error in mysql
SQL
0 vote187 views1 answer
Oracle list user locked
SQL
0 vote176 views1 answer
Select the date 30 days less that the todays date sql request
SQL

Share