MariaDB> SELECT TRIM('  bar   ');
        -> 'bar'
MariaDB> SELECT TRIM(LEADING 'x' FROM 'xxxbarxxx');
        -> 'barxxx'
MariaDB> SELECT TRIM(BOTH 'x' FROM 'xxxbarxxx');
        -> 'bar'
MariaDB> SELECT TRIM(TRAILING 'xyz' FROM 'barxxyz');
        -> 'barx'
