Database-mysql obtains the maximum value among multiple strings.

For example, the data YJV-3 * 50 + 1*25 to take the maximum value 50JKLGYJ-1-12020 to take the maximum value 120YJV-4*70 + 1*35 to take the maximum value 70 using the database built-in functions or their own function or other methods to achieve can hope you can more help for mysql databases

Such as data
YJV-3 * 50 + 1*25 max 50
JKLGYJ-1-120/20 max 120
YJV-4 * 70 + 1*35 max 70
You can use database built-in functions or self-built functions or other methods to achieve this.
Hope you can help me a lot.