Categories: Snippets

How do I check if a column is empty or null in mysql

SELECT * FROM table WHERE some_col IS NULL OR some_col = '';

 

Recent Posts

Generate Slug URL in MySQL

A slug is a short name using human-readable keywords to identify a web page. For…

5 years ago

How to use SQL LIKE condition with multiple values in PostgreSQL?

[crayon-663788d042d1b857192577/]  

6 years ago

SELECT Null

[crayon-663788d042e23385454734/]  

6 years ago

ALTER Column SET NOT NULL – pgSQL

[crayon-663788d042f02860393680/]  

6 years ago

ADD new Column – pgSQL

[crayon-663788d042ff4389319366/] [crayon-663788d042ffa939357509/]  

6 years ago