/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 vote284 views1 answer
Add computed column to table sql server
SQL
0 vote208 views1 answer
Get record which is available in one table but not in another mysql
SQL
2 votes199 views1 answer
Mariadb JSON_EXTRACT
SQL
2 votes209 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote218 views2 answers
Impala rename column name
SQL
3 votes371 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
22 votes219 views3 answers
SQL CHEATSHEET
SQL
0 vote208 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote197 views2 answers
Sql searching via key word
SQL
18 votes274 views3 answers
Get the list of all tables in sql server
SQL

Share