sql - 如何按空或零长度进行选择？

Question

我有疑问:

select text_b, id from articles where title is not null;

但我想显示 text_b 不为空且 text_b 的长度 > 0 的结果。怎么做？

Answer 1

select text_b, id 
from articles 
where title is not null
  and length(text_b) > 0;

或

select text_b, id 
from articles 
where title is not null
  and text_b <> '';

或正确处理 text_b 中的 null 值

select text_b, id 
from articles 
where title is not null
  and text_b is distinct from '';