DolphinDB sql语句里面，怎么查不包含？

Question

not like? 比如where province not like“%福建%”，这个试了跑不通。应该怎么写？

Answer 1

t=table("福建" "浙江" as value)
select * from t where not value  like "福%"