Lucene Query Syntax Cheat Sheet by sudhirdaruwala

Search for word "­foo­" in the title field

title: foo

Search for phrase "foo bar" in the title field

title: "foo bar"

Search for phrase "foo bar" in the title field AND the phrase "­quick fox" in the body field.

title:­"foo bar" AND body:"quick fox"

Search for either the phrase "foo bar" in the title field AND the phrase "­quick fox" in the body field, or the word "­fox­" in the title field.

(title­:"foo bar" AND body:"quick fox") OR title:fox

Search for word "­foo­" and not "­bar­" in the title field.

title:foo -title:bar

Search for any word that starts with "­foo­" in the title field.

title:foo*

Search for any word that starts with "­foo­" and ends with bar in the title field.

title:­foo*bar

Note that Lucene doesn't support using a symbol as the first character of a *search.

Search for "foo bar" within 4 words from each other.

"foo bar"~4

Range Queries allow one to match documents whose field(s) values are between the lower and upper bound specified by the Range Query. Range Queries can be inclusive or exclusive of the upper and lower bounds. Sorting is done lexico­gra­phi­cally.

mod_da­te:­[20­020101 TO 20030101]

Query-time boosts allow one to specify which terms/­clauses are "more import­ant­". The higher the boost factor, the more relevant the term will be, and therefore the higher the corres­ponding document scores.

A typical boosting technique is assigning higher boosts to title matches than to body content matches:

(title:foo OR title:­bar­)^1.5 (body:foo OR body:bar)

To search for all transa­ctions except MySQL transa­ctions:

NOT type: mysql

To search for all MySQL SELECT queries with large attach­ments:

mysql.m­ethod: SELECT AND mysql.s­ize: [10000 TO *]

Lucene also supports parent­heses to group sub queries.
To search for either INSERT or UPDATE MySQL queries with a respon­setime greater or equal with 30ms:

(mysql.me­thod: INSERT OR mysql.m­ethod: UPDATE) AND respon­set­ime:[30 TO *]