/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

3 votes322 views6 answers
Sql unique select
SQL
2 votes225 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
14 votes204 views4 answers
Online sql compiler
SQL
3 votes211 views2 answers
Wp do sql query from function
SQL
0 vote174 views1 answer
Heavy table in mysql
SQL
2 votes257 views2 answers
MySql FULL OUTER JOIN
SQL
1 vote196 views3 answers
Alter schema sql server
SQL
0 vote179 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote147 views1 answer
Mysql collation for all languages
SQL
0 vote196 views1 answer
How to print mysql query of codeigniter query builder
SQL

Share