/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 vote132 views1 answer
Neo4j display all nodes and relationships
SQL
1 vote137 views1 answer
Second last highest id in sql
SQL
1 vote162 views1 answer
How to get alternate records from a table in sql
SQL
0 vote129 views1 answer
Différence entre deux dates sql oracle
SQL
4 votes129 views1 answer
Sql any
SQL
15 votes133 views4 answers
Mysql where value is null
SQL
0 vote130 views2 answers
Get all index postgres
SQL
0 vote134 views1 answer
Compare subqueries oracle
SQL
6 votes132 views2 answers
Mysql get yesterday
SQL
0 vote138 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL

Share