/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 vote324 views1 answer
Find usage of table in sql server
SQL
0 vote307 views2 answers
Drop check constraint in ms sql
SQL
0 vote317 views4 answers
How to connect form to database
SQL
2 votes350 views1 answer
Where clause for child record apex
SQL
1 vote298 views1 answer
Mysql date diff in seconds
SQL
0 vote350 views1 answer
Create a plsql object
SQL
1 vote303 views1 answer
Oracle list constraints
SQL
3 votes272 views1 answer
Postgresql where current year
SQL
0 vote309 views1 answer
Sql beginning of previous month
SQL
0 vote318 views1 answer
Shell script to log mysql cpu usage
SQL

Share