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…

6 years ago

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

[crayon-67a5b37a62dc1259754874/]  

6 years ago

SELECT Null

[crayon-67a5b37a62eff235291967/]  

6 years ago

ALTER Column SET NOT NULL – pgSQL

[crayon-67a5b37a63010469524129/]  

6 years ago

ADD new Column – pgSQL

[crayon-67a5b37a631c3219101631/] [crayon-67a5b37a631c9051494145/]  

6 years ago