"not like" in 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%";

It returns the following error message:

Function not is not a binary operator

Does anyone know what I can do with it?

question from:https://stackoverflow.com/questions/65838918/not-like-in-dolphindb-sql

Answer 1

It doesnt support not like. Use not as follows:

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