/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 vote349 views1 answer
Create table with timestamp mysql youtube
SQL
0 vote334 views1 answer
What are the aggregate function in sql
SQL
4 votes327 views2 answers
How to count items with same name in sql
SQL
0 vote344 views2 answers
Clear window pl sql
SQL
1 vote403 views1 answer
UseSqlServer no definition
SQL
2 votes332 views1 answer
How to select first row of database sql
SQL
0 vote384 views1 answer
Date datatype in livesql
SQL
0 vote378 views1 answer
Data directory postgresql
SQL
0 vote327 views1 answer
Zsh: command not found: mysql mamp
SQL
5 votes361 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL

Share