/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 vote157 views1 answer
Rows to comma separated values in mssql
SQL
0 vote152 views1 answer
Postgresql like
SQL
3 votes151 views1 answer
Postgres kill running query
SQL
0 vote167 views1 answer
Typical max-connect-errors mysql
SQL
0 vote156 views1 answer
Change role postgres
SQL
0 vote166 views1 answer
Virtuoso sql query tutorial
SQL
9 votes165 views3 answers
Mysql run sql file
SQL
0 vote146 views1 answer
Sql compound operators
SQL
0 vote169 views1 answer
Combine 2 columns search query mysql
SQL
17 votes170 views5 answers
Order by sql
SQL

Share