SQL · Regular expressions and text search

websearch_to_tsquery()

Parses a user-friendly search query. PostgreSQL.

sqlRunnable example sql course

Syntax

websearch_to_tsquery(config, query)

Example

Open in the lab

-- PostgreSQL
-- SELECT websearch_to_tsquery('english', '"css layout" -grid');

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.