/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 vote304 views1 answer
Finish transaction sql
SQL
0 vote351 views1 answer
How to check even or odd in sql
SQL
0 vote379 views1 answer
How to list function in psql
SQL
9 votes359 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote352 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote388 views1 answer
How to write if case in select query in select statement
SQL
0 vote398 views1 answer
Mysql last friday of current month
SQL
10 votes359 views2 answers
Linux command line import mysql database
SQL
2 votes384 views1 answer
Q operator in plsql
SQL
10 votes373 views4 answers
Drop primary key
SQL

Share