"not like" 在 DolphinDB SQL 中

Question

t=table(`Gold`GoldMines`Silver`SilverMines as id, 1 2 3 4 as x);
select * from t where id not like "%Silver%";

返回以下错误信息:

Function not is not a binary operator

有人知道我可以用它做什么吗?

Answer 1

不支持not like。not的用法如下:

select * from t where not id like "%Silver%";