/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

1 vote229 views2 answers
Check if word is in column sql
SQL
22 votes237 views3 answers
Year format in date mysql
SQL
0 vote245 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote266 views1 answer
Sqlite schema structure of a relational database
SQL
3 votes237 views2 answers
Update Query in SQL Server
SQL
3 votes240 views1 answer
Sql add two values together
SQL
0 vote221 views1 answer
Querry mysql by 2 columns
SQL
0 vote224 views1 answer
Mysql set variable to today's date
SQL
1 vote221 views1 answer
Alter table column size oracle
SQL
0 vote236 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL

Share