/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 vote214 views1 answer
Postgres docs /copy metacomand
SQL
7 votes182 views1 answer
Oracle pagination query offset
SQL
33 votes187 views6 answers
Sql delete
SQL
1 vote172 views1 answer
Sql where last 12 months
SQL
17 votes203 views1 answer
Selecting name that contain certain word in sql
SQL
2 votes201 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
2 votes191 views1 answer
Revokeprivileges mysql
SQL
2 votes170 views2 answers
How to check database username and password in postgresql
SQL
0 vote177 views1 answer
Mysql preg replace
SQL
2 votes159 views1 answer
Mysql add boolean column
SQL

Share