I was wondering if there is a way to parse texts (such as business names) in Oracle SQL and search for components. For example, if my search word is '100 General Store Express', I would like to find records that contain all 4 components of my search word - '100', 'General','Store', 'Express' in any order.
So, if my records are :
1. 100 Express General Store
2. 100 General Store Express Way
3. 100 Express General
Then, the search would return only record 1 and 2.