Write Mysql query

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.

MySQL SQL

Projekt ID: #10513241

Om projektet