数据仓库服务 GAUSSDB(DWS)-比较和列表操作符:LIKE ALL/NOT LIKE ALL

时间:2024-12-10 11:28:48

LIKE ALL/NOT LIKE ALL

输入:LIKE ALL/NOT LIKE ALL
1
2
3
SELECT c1, c2
  FROM tab1
 WHERE c3 NOT LIKE ALL ('%STR1%', '%STR2%', '%STR3%');

输出

1
2
3
SELECT c1, c2
  FROM tab1
 WHERE c3 NOT LIKE ALL (ARRAY[ '%STR1%', '%STR2%', '%STR3%' ]);
support.huaweicloud.com/tg-dws/dws_16_0047.html