/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

2 votes114 views2 answers
Mysql add hours to time field
SQL
-2 votes119 views3 answers
Oracle tablespace usage
SQL
2 votes122 views1 answer
Oracle list grants on package
SQL
4 votes110 views2 answers
Oracle unliock account
SQL
0 vote153 views2 answers
Mysql cast to varchar
SQL
0 vote121 views2 answers
Oracle select
SQL
0 vote128 views1 answer
How to move a column to different spot mysql
SQL
0 vote120 views1 answer
Vbscript connect mssql
SQL
0 vote114 views2 answers
Sql if empty then
SQL
1 vote115 views2 answers
Sql server find all foreign keys that reference a column
SQL

Share