dig data from text

[BubikolRamios]

say I have table:

field1
bill
monica
...

and another table with text field, text field having large text files stored.

Any chance to get out something like this, using mysql, assuming one of text fields have text like that:
"....Bill gates is doing somethiing to monica lewinsky.... and monica lewinsky..."

expected result:

field1                      f
bill                      bill gates
monica                    monica lewinsky
monica                    monica lewinsky

[Old Pedant]

Yes. No. Sort of. For starters, you would only get "monica" once. You can only get one match out of a single record:

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.

[Old Pedant]

Actual demonstration:

mysql> select * from t1;
+--------+
| f1     |
+--------+
| bill   |
| monica |
+--------+
2 rows in set (0.00 sec)

mysql> select * from t2;
+---------------------------------------------------------------------------------+
| f2                                                                              |
+---------------------------------------------------------------------------------+
| ....Bill gates is doing somethiing to monica lewinsky.... and monica lewinsky.. |
| bill says that bill of attainders are fon                                       |
+---------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> select * from t1,t2 where t2.f2 like concat('%',t1.f1,'%');
+--------+---------------------------------------------------------------------------------+
| f1     | f2                                                                              |
+--------+---------------------------------------------------------------------------------+
| bill   | ....Bill gates is doing somethiing to monica lewinsky.... and monica lewinsky.. |
| monica | ....Bill gates is doing somethiing to monica lewinsky.... and monica lewinsky.. |
| bill   | bill says that bill of attainders are fon                                       |
+--------+---------------------------------------------------------------------------------+
3 rows in set (0.00 sec)