# Search text

Match text with patterns and supported text-search functions.

Source: https://particledb.ai/sql/full-text-search/

Match text with patterns and supported text-search functions.

## Example

```sql
CREATE TABLE docs_text (id BIGINT PRIMARY KEY, title TEXT);
INSERT INTO docs_text VALUES (1, 'Database guide'), (2, 'API reference');
```

```sql
SELECT id, title FROM docs_text WHERE title ILIKE '%database%';
SELECT to_tsvector('english', 'The quick fox') @@ to_tsquery('english', 'fox') AS matches;
```

## Behavior

Pattern matching and word search have different semantics. Neither is vector similarity search. Test tokenization, language handling and index use on your own data. A parser accepting an index declaration does not prove that a particular query uses that index.

## Related

[SQL reference](/sql/overview/) · [Application guide](/guides/relational-data/) · [Troubleshooting](/guides/troubleshooting/)
