Danbooru
Login Posts Comments Notes Artists Tags Pools Wiki Forum More ยป
Search Changes Help | Posts (0) History
  • Help
guro
scat
furry -rating:g

Recent Changes (all)

  • instrument insertion
  • hire me (synthesizer v)
  • guy-wire
  • sento-kun
  • nighthawk (madoka magica)
  • marisa (drivetech wear) (street fighter)
  • flower button
  • shirukuma riune
  • ao nhat binh
  • farmer (sekaiju)
  • marisa (outfit 3) (street fighter)
  • fuka (kuromaru)
  • void hunters (zenless zone zero)
  • stephanie sheh
  • sailor cosmos
  • neck ruff
  • flora cosmos
  • ririmu seraphin lucifer
  • star trail (vtuber)
  • gunner 2 (sekaiju)
  • listen flavor
  • lyrical nanoha
  • mr. blue (water challenge)
  • shun (small) (swimsuit) (blue archive)
  • marisa (outfit 2) (street fighter)

Options

  • Wiki History
  • Discussions
  • What Links Here

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
Terms / Privacy / Upgrade / Contact /