Indexing Words

[wxdqz]

I have a column of Business Name in one Table. I want to index word from Business Name in another table.

I was thinking of php script that explodes the Business Name into array then insert individual word as single record in another talbe.

Any other ways or suggestions?

Thanks
PP