mysql text字段判断是否为空

mysql text字段判断是否为空

mysql text字段为空
select * from `tableName` where `textField` is null or `textField` = '';

mysql text字段不为空
select * from `tableName` where `textField` is not null AND `textField` != '';

posted on 2016-12-02 16:38  kingofyz  阅读(5806)  评论(0)    收藏  举报

导航