/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

1 vote283 views2 answers
Sql queries practice
SQL
7 votes257 views1 answer
Grant schema permissions postgres
SQL
0 vote268 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote271 views1 answer
Mariadb used space
SQL
0 vote232 views1 answer
Connection error in mysql workbench
SQL
8 votes291 views2 answers
How to fetch data from database without last column
SQL
0 vote314 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote278 views1 answer
Oracle execute package dblink
SQL
0 vote319 views1 answer
Sql server phone constraint
SQL
0 vote291 views1 answer
Postgresql on conflict pair
SQL

Share