Hi, 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 column.
e.g 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? Mark http://www.bbc.co.uk/ 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.
