Documentation: 9.5 | regular expression sql
![Documentation: 9.5](https://i.imgur.com/axBPWDg.jpg)
TherearethreeseparateapproachestopatternmatchingprovidedbyPostgreSQL:thetraditionalSQLLIKEoperator,themorerecentSIMILARTOoperator(addedinSQL:1999),andPOSIX-styleregularexpressions.Asidefromthebasic"doesthisstringmatchthispattern?"operators,functionsareavailabletoextractorreplacematchingsubstringsandtosplitastringatmatchinglocations.stringLIKEpattern[ESCAPEescape-character]stringNOTLIKEpattern[ESCAPEescape-character]TheLIKEexpressionreturnstrueifthestringmatchesthesuppliedpattern.(Asexpected,...
![Documentation: 9.5](http://pix1.agoda.net/hotelimages/300/3008492/3008492_17121510550060424840.jpg?s=800x)
There are three separate approaches to pattern matching provided by PostgreSQL: the traditional SQL LIKE operator, the more recent SIMILAR TO operator (added in SQL:1999), and POSIX-style regular expressions. Aside from the basic "does this string match this pattern?" operators, functions are available to extract or replace matching substrings and to split a string at matching locations.
string LIKE pattern [ESCAPE escape-character] string NOT LIKE pattern [ESCAPE escape-character]The LIKE expression returns true if the string matches the supplied pattern. (As expected, the NOT LIKE expression returns false if LIKE returns true, and vice versa. An equivalent expression is NOT (string LIKE pattern).)
If pattern does not contain percent signs or underscores, then the pattern only represents the string itself; in that case LIKE acts like the equals operator. An underscore (_) in pattern stands for (matches) any single character; a percent sign (%) matches any sequence o...
取得本站獨家住宿推薦 15%OFF 訂房優惠
本站住宿推薦 20%OFF 訂房優惠,親子優惠,住宿折扣,限時回饋,平日促銷
Documentation: 9.5 | regular expression sql
How Regex in SQL works | regular expression sql
How to use Regex in SQL | regular expression sql
How to Use Regex in SQL? | regular expression sql
MSSQL Regular expression | regular expression sql
MySQL 5.5 Reference Manual : | regular expression sql
MySQL 8.0 Reference Manual | regular expression sql
MySQL | regular expression sql
regex in sql | regular expression sql
Regular Expressions in SQL | regular expression sql
Regular Expressions in SQL Server Databases | regular expression sql
SQL Contains String – SQL RegEx Example Query | regular expression sql
SQL RegEx | regular expression sql
sql server | regular expression sql
SQL 語法SELECT REGEXP | regular expression sql
T | regular expression sql
T-SQL Regular expression | regular expression sql
Using RegEx in SQL Server | regular expression sql
[ASP.NET]正規運算式剖析SQL基本指令(Using Regular ... | regular expression sql
使用規則運算式搜尋文字 | regular expression sql
![](https://i.imgur.com/axBPWDg.jpg)