/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

5 votes179 views1 answer
Sql integer to serial
SQL
0 vote209 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote184 views1 answer
Sql get year from datetime field
SQL
0 vote168 views1 answer
T sql cursor tr
SQL
3 votes320 views6 answers
Sql unique select
SQL
1 vote204 views1 answer
Apex run 404
SQL
0 vote197 views1 answer
Login failed for user sql server
SQL
1 vote166 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
2 votes168 views1 answer
Columns Present in a table
SQL
6 votes178 views2 answers
Foreign key sqlite3 python
SQL

Share