/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 vote363 views1 answer
Generate random & unique mysql string
SQL
65 votes572 views6 answers
Sql add column to table
SQL
1 vote332 views1 answer
Create sample data postgresql
SQL
1 vote358 views1 answer
Cross schema query oracle 2 users
SQL
28 votes358 views4 answers
Delete database mysql
SQL
1 vote357 views1 answer
Select dba users oracle
SQL
0 vote350 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote326 views1 answer
Power query datetime to date
SQL
9 votes330 views4 answers
How to remove duplicate in sql
SQL
0 vote362 views1 answer
Sql show table name in result
SQL

Share