/SQL/Mysql remove first and last character from string

Mysql remove first and last character from string

/* remove any first & last character in mysql*/
SELECT substring(myfield,2, length(myfield)-2) FROM mytable;

Mysql remove first and last character from string

SELECT TRIM(BOTH ',' FROM name) from users; /*trim leading and trailing ,*/
SELECT TRIM(LEADING ',' FROM name) from users;/*trim leading,*/
SELECT TRIM(TRAILING ',' FROM name) from users; /*trim trailing,*/

Similar codes

0 vote169 views1 answer
How to create a new db from dumb file mysql
SQL
7 votes172 views2 answers
Where keyword sql
SQL
5 votes161 views1 answer
Sql check if date is between 2 dates
SQL
0 vote115 views2 answers
Avg() sql
SQL
0 vote113 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote155 views1 answer
How to to get current date in sql
SQL
0 vote159 views1 answer
Mysql events not work
SQL
8 votes140 views1 answer
Sql remove characters from string right
SQL
0 vote155 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
2 votes203 views1 answer
Oracle Column Names of a table
SQL