This is only a quick reference of the main syntax Derpibooru's search engine supports. For additional examples, even more search options, and in-depth documentation, visit the search syntax page.
- Supported Fields
- Numeric Range Queries
- Wildcards
- Boolean Operators
Supported Fields
| Field Selector | Type | Description | Example |
|---|
aspect_ratio | Numeric Range | Matches any image with the specified aspect ratio. | aspect_ratio:1 |
comment_count | Numeric Range | Matches any image with the specified number of comments | comment_count.gt:50 |
description | Full Text | Full-text search against image descriptions with the specified string. | description:derp |
downvotes | Numeric Range | Matches any image with the specified downvote count. | downvotes:0 |
faved_by | Literal | Matches any image favourited by the specified user. Case-insensitive. | faved_by:roboshi |
faves | Numeric Range | Matches any image with the specified number of favourites. | faves:20 |
height | Numeric Range | Matches any image with the specified width. | height:1080 |
orig_sha512_hash | Literal | Matches the original SHA-512 checksum of an uploaded image. | |
score | Numeric Range | Matches any image with the specified net score. | score.gt:200 |
source_url | Literal | Matches image source URLs. Case-insensitive. | source_url:*deviantart.com* |
sha512_hash | Literal | Matches any image with the specified SHA-512 checkusm. N.B.: Image optimization usually alters the original checksum! | |
uploader | Literal | Matches any image with the specified uploader account. Case-insensitive. | uploader:k_a |
upvotes | Numeric Range | Matches any image with the specified upvote count. | upvotes.gt:200 |
width | Numeric Range | Matches any image with the specified width. | width:1920 |
created_at | Date/Time Range | Matches any image posted at the specified date and/or time. | created_at:2015-04-20 |
Numeric Range Queries
A qualifier can be added to the end of a numeric range field name with a single period to indicate desired results that are greater than or less than the supplied value; the value can be optionally included, too. To find images with a score greater than 100, we would enter score.gt:100. For an inclusive search of scores greater than or equal to 100, we would instead enter score.gte:100. The following table enumerates the supported qualifiers.
| Qualifier | Meaning | Example |
|---|
gt | Values greater than specified, and not including the specified value | score.gt:100 |
gte | Values greater than or equal to specified | score.gte:100 |
lt | Values less than specified, and not including the specified value | width.lt:100 |
lte | Values less than or equal to specified | width.lte:100 |
Wildcards
An asterisk "expands" or matches to any number of characters in its place, including 0. For example, apple* matches to uploads with any of the tags apple bloom , applejack , and simply apple.
A question mark matches to a single character in its place. For example, t?ixie can match to either trixie or twixie.
| Wildcard Character | Match | Example |
|---|
* | Zero or more characters | apple* |
? | A single character | t?ixie |
Boolean Operators
Boolean operators listed in order of precedence. That is, twilight sparkle || fluttershy && pinkie pie is the same as twilight sparkle || (fluttershy && pinkie pie) . Note that parentheses are sometimes used in tags, for example rose (flower) or sonic rainboom (episode)
| Operator | Symbols | Comments | Examples |
|---|
| Negation (NOT) | | Applied in front of a single term or parenthesized subexpression. The minus sign does not require padding to the right. Specifies that the term or subexpression must not match. | |
| Conjunction (AND) | | Applied between two terms. The comma may be optionally padded with space on either side; the other forms must be padded. Specifies that both terms match. Can be chained to more terms. | |
| Disjunction (OR) | | Applied between two terms, with surrounding space. Specifies that either of the terms match. Can be chained to more terms. | |