/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 vote285 views1 answer
Mysql money value
SQL
1 vote288 views1 answer
Install postgresql on raspberry pi
SQL
0 vote280 views1 answer
Mysql command prompt date insert format
SQL
0 vote321 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
1 vote342 views1 answer
Oracle select first row order by
SQL
14 votes309 views5 answers
Sql oracle limit
SQL
0 vote285 views1 answer
Create new table pl sql
SQL
1 vote310 views1 answer
Hackerrank sql test solutions
SQL
7 votes298 views6 answers
Group_concat in mysql
SQL
0 vote315 views1 answer
Running mysql from bash sc
SQL

Share