TRIM( [ LEADING | TRAILING | BOTH ] [ trim_character FROM ] string )

Select trim(' lidihuo ');

Select trim(leading 'mysql' from 'mysql_lidihuo ');

Select trim(both 'mysql' from 'mysql_lidihuo_mysql');

Select trim(trailing 'mysql' from 'lidihuo_mysql');