/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 vote159 views1 answer
Search In the Data using ObjectName
SQL
1 vote134 views1 answer
Sql Split string function
SQL
8 votes173 views1 answer
My sql version
SQL
0 vote154 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote142 views1 answer
Sql how to display two atributes as one in sql
SQL
17 votes200 views2 answers
How to assign date field for table in mysql
SQL
1 vote152 views1 answer
Convert varchar to int in sqlite
SQL
17 votes178 views4 answers
Mysql remove ubuntu
SQL
1 vote152 views1 answer
Postgres start database on linux
SQL
22 votes144 views4 answers
Show list of users in mysql
SQL

Share