help:text syntax

When searching text fields, in addition to the parameters that string syntax accepts, they also accept the *_matches parameter. When a string contains the wildcard "*", then it is treated the same as a *_like parameter. Otherwise it searches the lexical patterns for a match. This follows Postgres's text matching.

See also

• Help:String syntax
• Help:API

External links

• Postgres article on regular expressions
• Postgres article on text matching
• https://github.com/danbooru/danbooru/blob/master/app/logical/concerns/searchable.rb