lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mark Swinson" <>
Subject indexing individual terms in large database field.....
Date Thu, 13 Oct 2011 15:58:23 GMT

I'm trying to index a recipe database which contains , amongst other things, a list of ingredients
stored as free text in a single mysql


2 apple bananas (or ordinary bananas), peeled 
50g/2oz soft brown sugar
100g/3┬Żoz self-raising flour
1 free-range egg, beaten
3-4 tbsp sparkling water
500ml/18fl oz vegetable oil, for deep frying
50g/2oz caster sugar
25g/1oz butter
2 apple bananas (or ordinary bananas), peeled and halved lengthways

One problem I'm trying to solve is to be able to search for an individual ingredient , e.g
bannas~ ( fuzzy search ) and return
the closest match from within the field. However I am unsure how to index this column so that
I can return a single match.

Can solr support this sort of thing out of the box, or will I need to write a custom plugin?

This e-mail (and any attachments) is confidential and may contain personal views which are
not the views of the BBC unless specifically stated.
If you have received it in error, please delete it from your system.
Do not use, copy or disclose the information in any way nor act in reliance on it and notify
the sender immediately.
Please note that the BBC monitors e-mails sent or received.
Further communication will signify your consent to this.

View raw message