/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 vote247 views3 answers
My sql alter table
SQL
1 vote274 views1 answer
Sql server set variable if exists
SQL
0 vote222 views1 answer
Update set with join pl sql
SQL
2 votes235 views2 answers
Checking data type in sql server
SQL
2 votes240 views1 answer
How to insert string variable into sqlite database
SQL
0 vote230 views2 answers
Clear window pl sql
SQL
0 vote227 views1 answer
Select row from mysql where date more than 30 days
SQL
5 votes224 views2 answers
Copy data from one database to another
SQL
1 vote263 views2 answers
This month mysql where
SQL
0 vote239 views1 answer
Login failed for user sql server
SQL

Share