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…

7 years ago

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

[crayon-692e603046455393380481/]  

7 years ago

SELECT Null

[crayon-692e60304658f381894463/]  

7 years ago

ALTER Column SET NOT NULL – pgSQL

[crayon-692e6030466a3931889429/]  

7 years ago

ADD new Column – pgSQL

[crayon-692e60304679b984723923/] [crayon-692e60304679f024524210/]  

7 years ago