/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

2 votes223 views1 answer
Oracle index size
SQL
9 votes220 views2 answers
Get first 3 letters in sql
SQL
1 vote219 views1 answer
Loading local data is disabled mysql
SQL
0 vote221 views1 answer
Sql server manager close connection
SQL
0 vote227 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
1 vote223 views1 answer
Add sequence postgres
SQL
0 vote229 views1 answer
Sql server bool select
SQL
0 vote318 views1 answer
Oracle db timestamp auto add
SQL
11 votes245 views6 answers
Distinct sql
SQL
49 votes243 views6 answers
Mysql add column to table
SQL

Share