/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 vote180 views1 answer
Oracle last character of string
SQL
0 vote235 views1 answer
Pl sql round
SQL
0 vote182 views1 answer
Insert set mysql
SQL
0 vote194 views2 answers
Postgres show current role
SQL
0 vote211 views1 answer
Data types mysql vs postgresql
SQL
11 votes190 views6 answers
Distinct sql
SQL
3 votes195 views1 answer
Pl sql escape &
SQL
0 vote185 views2 answers
How to know the character set of an oracle databes
SQL
0 vote186 views1 answer
Sql last 7 days
SQL
1 vote209 views1 answer
Mysql previous year
SQL

Share