Online Notes
SQL

Recent SQL Snippets

  • Generate Slug URL in MySQL
  • How to use SQL NOT LIKE condition with multiple values in PostgreSQL?
  • How to use SQL LIKE condition with multiple values in PostgreSQL?
  • SELECT Null
  • ALTER Column SET NOT NULL – pgSQL
  • ADD new Column – pgSQL
  • WITH RECURSIVE
  • UPDATE from SELECT
  • Switch case (UPDATE)
  • INSERT from SELECT

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

  • Snippets

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

 

Related posts

  • SQL Introduction
  • SELECT Null
  • What are the different SQL JOINs ?
  • UPDATE from SELECT
  • Backup & Restore Database in PostgreSQL
  • How to use SQL NOT LIKE condition with multiple values in PostgreSQL?
  • How to use SQL LIKE condition with multiple values in PostgreSQL?
  • KILL ALL EXISTING CONNECTION FROM DB – PostgreSQL
  • MySql Login, Database & User Creation
  • Switch case (UPDATE)

Recent Snippets

  • How to Install Angular on Ubuntu (18.04 & 16.04)
  • Install Node.js in Ubuntu
  • Angular CLI & Troubleshooting
  • Simple POJO Example - Employee
  • Hibernate Example Configuration File — hibernate.cfg.xml

Recent Examples

  • How to reverse Singly Linked List?
  • Find out duplicate number between 1 to N numbers.
  • Find out middle index where sum of both ends are equal
  • Write a singleton class in Java
  • Write a java program to reverse a string?

Recent Questions

  • What are the modules of spring framework?
  • List some of the Spring Framework Annotations?
  • How many types of association mapping are possible in hibernate?
  • Define persistent classes?
  • What is HQL?

  • Contact

All Right Reserved © Online Note