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