查询sh_goods表中价格在2000到6000的商品信息,语句为select * from sh_goods where price () 2000 () 6000;
查询sh_goods表中关键词不为空的商品信息,语句为:select * from sh_goods where keyword ();
查询sh_goods表中商品名称中含有“笔”的商品信息,语句为:select * from sh_goods where name ();
查询sh_goods表中描述字段内含有“人”或“必备”词语的商品信息,语句为:select * from sh_goods where content () '人|必备';