mysql trim characters code example

Example 1: mysql trim spaces

`field` = TRIM(`field`);

Example 2: mysql trim characters

SELECT TRIM('=' FROM '=FRESH COOKIES!=') AS Trimmed;
SELECT TRIM('=' FROM '====FRESH COOKIES!====') AS Trimmed;