Examples: query, "exact match", wildcard*, wild?ard, wild*rd
Fuzzy search: cake~ (finds cakes, bake)
Term boost: "red velvet"^4, chocolate^2
Field grouping: tags:(+work -"fun-stuff")
Escape special characters +-&|!(){}[]^"~*?:\ - e.g. \+ \* \!
Range search: properties.timestamp:[1587729413488 TO *] (inclusive), properties.title:{A TO Z}(excluding A and Z)
Combinations: chocolate AND vanilla, chocolate OR vanilla, (chocolate OR vanilla) NOT "vanilla pudding"
Field search: properties.title:"The Title" AND text
Profile picture
Chris Chandler
Moderator
1 Question, 1 Answer
  Active since 30 March 2021
  Last activity 2 years ago

Reputation

10 3 2

Badges 2

Eureka! Newbie
1 Votes
2 Answers
4K Views
1 Votes 2 Answers 4K Views
I've taken a look at the Scoold schema in MariaDB and it's pretty flat. Really just a single table with text fields for storing the content as JSON. Given th...
2 years ago
1 Any database preference for Scoold?

Gotcha! Thanks for the reply!

2 years ago