Need your thoughts about fulltext search

Hi all,

I have an assignment to create frontend application based on yii2 on top of some old and "bad" system ( database ).

Old system is using solr, and in database have one table that is collecting data from many forms ( entities ) on insert/update. That table is very bad, because there is no option to identify to what entity some information belongs ( all data is put in one table field ), so when you do search for something you will get results that are not really related with the term that you are searching for.

I am supposed to create search in my yii2 frontend application that is using solr facilities ( or provide alternative without changing database structure ).

How would you go about this ?

Solr is OK for the job.