Partial Match Search Query
I've asked a few questions on this forum now and the response has been absolutely magic. I feel like I'm taking the mick a bit so I will do my best to help with anyone else's questions as they come up to return the favour.
Here's my latest one:
I need to run a query on a column in my table to find partially matching fields, so where the column contains fields with "D.Brown" and "Dave Brown" I need the query to pick those fields up and return them as similar fields.
I think this is a really complex query to run as it isn't as simple as when you have a reference to compare with using LIKE '%Brown%'. I need the query to "detect" matches using some kind of percentage comparison or REGEXP maybe. I'm using workbench if anyone knows of a plugin that could assist.
Any advice would be gratefully received.
Thanks in advance.:thumbsup: