I have a MySQL database with a table that contains 2 importants fields title and age_range.
That table saves documents like this
45;60 for documents designed for users between 45 and 60 years old,
18;70 for users between 18 and 70 years old and so on...
Now I would like to fire the query
test on the field title with the filter
18;50 for the field age_range that will return all documents matching
test with the age range field contained in this interval including the 2 the 2 cases above for example.
For instance, I use Logstash to index my data.
How can I achieve this?
Any treatment to do while indexing my data with logstash?
Any filter, tokenizer to use while indexing using ES analyzer?
Thank you in advance