Here is what I am trying to do.
User (a): Enters data in two fields (description-1) and (description-2).
User (b) Enters similar data in opposite fields.
User (a) or (b) a search in both fields will find a match.
A good analogy would be dating. User (a) enters a description of themselves and the match they are looking for, and User (b) enters a description of themselves and the match they are looking for, and both can search and find a match.
So, in psuedo query english ...
Select a name from the data where me = 'target' and target = 'me'
The catch will be, some words in the field will match, but not all.
source
share