Skip to content

Instantly share code, notes, and snippets.

@brikis98

brikis98/bql_example.sql

Created January 26, 2012 18:50
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save brikis98/1684331 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save brikis98/1684331 to your computer and use it in GitHub Desktop.
Download ZIP
Sensei BQL example
Raw
bql_example.sql
SELECT _uid,_score,color
FROM members
WHERE color="red" AND
category IN ("van","exotic") AND
MATCH(contents)
AGAINST("cool leather seats")
GROUP BY color TOP 3
BROWSE BY color,category
ORDER BY RELEVANCE
LIMIT 0,10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment