Write Mysql query for the text processing -- 2

Project Description Help us to prepare Mysql query which deliver the result with minimal resources and time to execute. Case as below - For data in same db, table, record text 1: This is text 1 text 2: Text 2 is here text 3: Phrase 3, will be displayed here text 4: This is text number - 4 text 5: Text five here some additional process 1. remove some predefined symbol, eg: , - 2. case insensitive Result: (string | occurence | %) text | 4 | 80% ; this | 2 | 40% ; is | 2 | 40% ; here | 3 | 40% ; phase | 1 | 20%; 1 | 1 | 20% .......etc This query has to handle similar cases above for over million of records If deliverable is in good quality, more similar job in future on designing Mysql query will be offered.