/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 vote189 views1 answer
Mysql column start with string
SQL
0 vote178 views1 answer
Resullt all update knex mysql
SQL
244 votes477 views14 answers
Sql n insert
SQL
1 vote169 views1 answer
Sql server 2012 query history
SQL
1 vote241 views1 answer
Continue in sql
SQL
0 vote178 views1 answer
Mysql in clausule string array
SQL
0 vote188 views1 answer
Sql output select
SQL
0 vote182 views1 answer
Kill thread
SQL
0 vote223 views1 answer
Mysql order by where condition sub query
SQL
0 vote186 views1 answer
OFFSET consulta mysql
SQL

Share