PostgreSQL中的Putting multiple LIKE patterns into an array特性是什么

本篇内容主要讲解“PostgreSQL中的Putting multiple LIKE patterns into an array特性是什么”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“PostgreSQL中的Putting multiple LIKE patterns into an array特性是什么”吧!LIKE用于模糊查询，如select
from tablename where column like ‘%value%’；如需要多个模糊匹配则需要使免费主机域名用多个like子句，如select from tablename where column 免费主机域名like ‘%value1%’ or column like ‘%value2%’ or column like ‘%value3%’或者select * from tablename where column like ‘%value1%’ and column like ‘%value2%’ and column like ‘%value3%’。PG提供了ANY/ALL结合ARRAY来简化SQL：select
from tablename where column like ‘%value1%’ or column like ‘%value2%’ or column like ‘%value3%’
->
select from tablename where column like ANY(ARRAY[‘%value1%’,’%value2%’,’%value3%’])select
from tablename where column like ‘%value1%’ and column like ‘%value2%’ and column like ‘%value3%’
->
select from tablename where column like ALL(ARRAY[‘%value1%’,’%value2%’,’%value3%’])测试脚本到此，相信大家对“PostgreSQL中的Putting multiple LIKE patterns into an array特性是什么”有了更深的了解，不妨来实际操作一番吧！这里是云技术网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！

相关推荐: MySQL中MHA基本配置及注释的示例分析

这篇文章主要介绍MySQL中MHA基本配置及注释的示例分析，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！#*************************************************app scope*******…