/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

3 votes274 views2 answers
Sqlite show table definition
SQL
0 vote283 views1 answer
Hw to delete a procedure in pl sql
SQL
12 votes291 views4 answers
Mysql get date difference in hours
SQL
3 votes300 views1 answer
Start mysql server by terminal in linux
SQL
6 votes275 views2 answers
Can't connect to local mysql server through socket
SQL
1 vote307 views1 answer
Sql server today minus n
SQL
0 vote292 views1 answer
Test database for sql
SQL
0 vote329 views1 answer
Stratified sampling sql
SQL
0 vote297 views1 answer
Database xml sql
SQL
2 votes278 views2 answers
How to get capital letter first in sql
SQL

Share