bookmark

sql - How do I check if a column is empty or null in MySQL? - Stack Overflow


Description

WHERE some_col > '' Since null > '' produces unknown, this has the effect of filtering out both null and empty strings.

@JoshPinter: coalesce(some_col, '') = ''

Preview

Tags

Users

  • @jil

Comments and Reviews