Yes. No. Sort of. For starters, you would only get "monica" once. You can only get one match out of a single record:
Code:
SELECT T1.field1, T2.f
FROM someTable AS T1, anotherTable AS T2
WHERE T2.f LIKE CONCAT('%',T1.field1,'%')
ORDER BY T1.field1
Also, how do you expect to get "bill gates" when the search term is just "bill"? Suppose the text said "....bill says that Bill of attainder is doing somethiing to monica lewinsky.... and monica lewinsky.."
That's going to find "bill" just the same as it would find "bill" in "bill gates".
In the above, would you expect then to find "bill of" or "bill of attainder" or "bill says" or????
You can only find what you search for.