/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 vote222 views1 answer
Create query in where clasue
SQL
0 vote218 views1 answer
Mysql error 1251
SQL
4 votes318 views6 answers
Laravel jwt
SQL
1 vote227 views1 answer
Add sequence postgres
SQL
0 vote212 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote168 views1 answer
Mysql offset from bottom
SQL
0 vote212 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
5 votes217 views1 answer
Mysql count lines
SQL
1 vote221 views2 answers
Mysql trim spaces
SQL
2 votes191 views1 answer
Drop table purge
SQL