search

Searches text-like data.

Syntax

search( <search_data>, query => <query> [, analyzer => <analyzer> ] )

Arguments

<search_data>

The data you want to search. This can be string, array, object, or any.

<query> (named)

A string that contains one or more search terms. This argument must be a literal string; column names are not supported. Specify one pair of single quotes around the entire string.

<analyzer> (named) (optional)

The analyzer to use for the search. Supported values:

• log

The default value is log.

Returns

Returns a boolean.

• The value is TRUE if any <query> tokens are found in <search_data>.
• Returns NULL if either of these arguments is NULL.
• Otherwise, returns FALSE.

Examples

VALUES ('foo bar'), ('foobar'), ('bar baz'), ('') SELECT *, search($0, query => 'foo');

+---------+----------------------------+
| $0      | search($0, query => 'foo') |
+---------+----------------------------+
| foo bar | true                       |
| foobar  | false                      |
| bar baz | false                      |
|         | false                      |
+---------+----------------------------+