/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 vote330 views1 answer
Oracle sql log to console
SQL
2 votes327 views1 answer
Set username and password for postgresql database
SQL
0 vote436 views1 answer
Php insert null mysql
SQL
24 votes348 views5 answers
Import dump mysql
SQL
1 vote321 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
3 votes397 views2 answers
Oracle drop sequence
SQL
0 vote318 views1 answer
Codigo crear tablas sql server
SQL
0 vote324 views1 answer
Find invalid datetime field
SQL
0 vote301 views1 answer
Ms sql unique
SQL
0 vote330 views1 answer
How to select an index in oracle sql
SQL

Share