/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 vote190 views1 answer
First mysql
SQL
20 votes207 views6 answers
Mysql reset auto increment
SQL
0 vote193 views1 answer
Dns slave zone convert
SQL
1 vote187 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote218 views1 answer
Separator mysql
SQL
0 vote195 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote201 views1 answer
Oracle session statistics
SQL
2 votes212 views4 answers
2nd highest salary in mysql
SQL
0 vote258 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote203 views1 answer
Nosql vs sql
SQL