solr查询非空值的方法
q=FieldName:['' TO *]
相当于在sql中执行:
SELECT field_name FROM some_table WHERE field_name IS NOT NULL;
查询某列大于0的记录
q=FieldName:[1 TO *]对应的sql:
SELECT field_name FROM some_table WHERE field_name > 0;
solr查询非空值的方法
q=FieldName:['' TO *]
相当于在sql中执行:
SELECT field_name FROM some_table WHERE field_name IS NOT NULL;
查询某列大于0的记录
q=FieldName:[1 TO *]对应的sql:
SELECT field_name FROM some_table WHERE field_name > 0;