/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 vote395 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote160 views1 answer
Shows all databases created by user in ms sql
SQL
1 vote185 views1 answer
Apex run 404
SQL
0 vote161 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote190 views1 answer
Mysql loop through databases and execute query
SQL
17 votes150 views3 answers
Cast in sql server
SQL
0 vote153 views1 answer
SQL add a totals of differemt rows of the same id
SQL
38 votes208 views6 answers
Alter table mysql
SQL
0 vote143 views1 answer
How to reset AI in sql
SQL
14 votes146 views4 answers
Remove record from table sql
SQL

Share