/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 vote365 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
0 vote349 views3 answers
Sql query checker
SQL
0 vote333 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
0 vote335 views1 answer
Drop unique
SQL
1 vote366 views1 answer
Mysql select from outside
SQL
1 vote336 views1 answer
Alter constraint postgres
SQL
17 votes319 views5 answers
Order by sql
SQL
10 votes321 views3 answers
Insert into auto increment mysql
SQL
7 votes356 views3 answers
Convert ansi sql
SQL
1 vote359 views1 answer
Round function in sql oracle
SQL

Share