/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 vote338 views1 answer
Mysql collation portugues brasil
SQL
0 vote280 views10 answers
John the ripper mysql
SQL
17 votes352 views3 answers
Postgresql list users
SQL
0 vote407 views1 answer
Oracle db timestamp auto add
SQL
5 votes307 views1 answer
Ora-00054 find lock
SQL
0 vote282 views1 answer
Install mysql 8 linux
SQL
16 votes334 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
0 vote318 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote269 views8 answers
Convert sql query to linq online
SQL
0 vote309 views1 answer
Set classpath for mysql-connector.jar
SQL

Share