I need an advice with searching of record based on specified string. In the table I have columns like:
- country
- city
- street
- house number
- post code
Search strings can contain values from these columns. Values in this string don´t have to be strictly identical given in the correct order and also the values of some columns in this string may be missing.
Example of table record:
|country|city|street |house number|post code|
|-------|----|---------------|------------|---------|
|Austria|Wien|Kärntner Strabe|22 |2000 |
Example of search string:
22 Karntner Wien
And I get for example result with top 5 similar records.
I think I should use full text search, but I have no experiences with it. Can you tell me how to proceed?