/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 vote180 views1 answer
Oracle procedure teamplate
SQL
4 votes201 views3 answers
Sqlite show columns
SQL
0 vote165 views1 answer
Replace multiple string in query sql
SQL
0 vote200 views1 answer
How to get table id sequence postgres
SQL
6 votes178 views1 answer
Postgres get size of database
SQL
0 vote178 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote127 views1 answer
How to connect sql server using ip address in c#
SQL
44 votes251 views6 answers
Rename command in sql
SQL
0 vote170 views1 answer
Dump only data
SQL
0 vote128 views1 answer
Split a string with expression and get the last value of split sql
SQL

Share