I need to get a particular column ‘value’ where it has alot of characters looks like a short paragraph, now i want a string Pretest_Score=25 i.e., it should display 25

in my table. How could be this done?. Please kindly help me with exact sql query.

SELECT TRIM(‘value’) FROM mdl_sample