/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 votes134 views1 answer
How to add unique constraint in mysql table
SQL
2 votes105 views2 answers
Laravel query builder toSql
SQL
1 vote99 views1 answer
Mysql select month and year
SQL
2 votes93 views1 answer
Oracle drop sequence if exists
SQL
1 vote118 views1 answer
Sql random sampling per group
SQL
7 votes101 views1 answer
Sql server convert string to date
SQL
3 votes137 views1 answer
Query less than datetime sql
SQL
2 votes93 views1 answer
Sql to char function with date
SQL
1 vote105 views1 answer
Update foreign key value in mysql
SQL
0 vote101 views1 answer
C# datetime to sql server datetime
SQL

Share