/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

7 votes195 views2 answers
Html to react converter
SQL
3 votes282 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
1 vote188 views1 answer
How to delete data from sql database in android
SQL
1 vote194 views1 answer
Sql update table remove spaces
SQL
3 votes261 views2 answers
Oracle drop column
SQL
2 votes194 views1 answer
Sql ignore accents
SQL
0 vote234 views1 answer
Mysql limit order by
SQL
5 votes209 views2 answers
Oracle rename table
SQL
1 vote227 views1 answer
Mysql select and count left join
SQL
8 votes182 views1 answer
Oracle add month
SQL

Share