/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

9 votes319 views2 answers
Oracle all tables in schema
SQL
7 votes352 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
8 votes306 views2 answers
Phpmyadmin password
SQL
-2 votes329 views1 answer
Remove root password mysql
SQL
0 vote342 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
40 votes433 views4 answers
PostgreSQL add column
SQL
1 vote335 views1 answer
Drop df constraint sql server
SQL
0 vote323 views1 answer
Groupby error in mysql
SQL
11 votes322 views2 answers
Safe mode off mysql
SQL
0 vote336 views1 answer
Convert rows to columns in sql server
SQL

Share