/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

2 votes282 views2 answers
Sqlalchemy return id after insert
SQL
4 votes260 views3 answers
Order by value mysql
SQL
-1 vote275 views1 answer
Get month and year from date in mysql sequelize
SQL
3 votes284 views5 answers
Duplicate table sql
SQL
0 vote287 views1 answer
Copying query result to excel
SQL
7 votes267 views1 answer
Sql disable safe mode
SQL
6 votes260 views2 answers
Where clause in sql
SQL
0 vote290 views1 answer
Command line mysql xampp
SQL
12 votes262 views2 answers
Delete entries in postgresql
SQL
0 vote262 views1 answer
T sql less than date
SQL

Share