In this post I would like to write about MySQL
trim()function.MySQL trim() function removes the specified characters from beginning and ending of the string and returns a string after removing all prefixes or suffixes.
NOTE :trim() function only trim excess space or specified characters on the left and right side of the text, not in between.
The syntax for the tirm() function in MySQL is:
TRIM( [ LEADING | TRAILING | BOTH ] [ trim_character FROM ] string )
‘FROM’ IS A KEYWORD
Optional. Indicates that only leading prefixes are to be removed. .
Optional. Indicates that only trailing prefixes are to be removed. .
Optional. Removes the trim_character from the front and end of string.
Optional. The character that will be removed from string. If this parameter is omitted, it will remove space characters from string.
The string to trim.
you can use trim() function in select as shown below
SELECT TRIM(title) AS title FROM your_table
if you want to remove leading trailing quote form the MySQL row and update it you can write as shown below
title = TRIM(BOTH '"' FROM
To remove other type of characters just replace quote with the targeted character.
I hope you like this Post, Please feel free to comment below, your suggestion and problems if you face - we are here to solve your problems.