/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 vote197 views1 answer
Oracle free up space in tablespace
SQL
7 votes218 views3 answers
Sql set
SQL
9 votes203 views6 answers
Sql add column with default value
SQL
0 vote182 views1 answer
Create dabase postgresql
SQL
0 vote215 views1 answer
Stored procedures example
SQL
9 votes231 views2 answers
SELECT User,Host FROM mysql.user;
SQL
0 vote229 views1 answer
Mysql disable triggers
SQL
0 vote203 views1 answer
Mariadb errno 121
SQL
0 vote170 views1 answer
Mysql timeout 30 seconds
SQL
1 vote203 views1 answer
How refresh navicat tables to see new tables
SQL

Share