/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 vote179 views1 answer
Joins vs includes
SQL
0 vote201 views1 answer
Returning with sqlalchemy
SQL
0 vote186 views2 answers
Sql count number of rows after group by
SQL
0 vote218 views1 answer
Netstat -tln mysql
SQL
1 vote210 views3 answers
Sql union
SQL
0 vote186 views1 answer
MySql get primary keys of table
SQL
3 votes200 views3 answers
Start postgresql ubuntu
SQL
0 vote227 views1 answer
Doctors appointment
SQL
0 vote188 views1 answer
Psql no such file or directory
SQL
0 vote202 views1 answer
Oarcale list objects
SQL