String Functions & Operators
String manipulation, pattern matching, regex, collation, and text search.
0 features
but not in
Rules for string comparison, sorting, and equality that account for case, accent marks, locale, and Unicode normalization.
collationCOLLATEcase-insensitiveaccent-insensitiveICUcitextlocalecharacter set
Postgres
MySQL
MariaDB
Oracle
SQL Server
SQLite
Redshift
DB2
Snowflake
BigQuery
Native database support for indexing and searching text by relevance, stemming, and linguistic analysis.
full-text searchFTSFULLTEXTtsvectortsqueryMATCH AGAINSTCONTAINSFREETEXTFTS5
Postgres
MySQL
MariaDB
Oracle
SQL Server
SQLite
Redshift
DB2
Snowflake
BigQuery
Pattern matching against string values using regular expression syntax.
regexregexpregular expressionREGEXP_LIKEREGEXPpattern matching
Postgres
MySQL
MariaDB
Oracle
SQL Server
SQLite
Redshift
DB2
Snowflake
BigQuery
Concatenate string values from multiple rows into a single string, optionally with a delimiter and ordering.
STRING_AGGGROUP_CONCATLISTAGGWM_CONCATstring aggregationconcatenation aggregate
Postgres
MySQL
MariaDB
Oracle
SQL Server
SQLite
Redshift
DB2
Snowflake
BigQuery