/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

2 votes267 views4 answers
Sql query interview questions
SQL
0 vote258 views2 answers
Sql regex vowel
SQL
0 vote373 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
3 votes264 views2 answers
Find the median in sql
SQL
0 vote262 views5 answers
Sql table intermédiaire
SQL
0 vote260 views1 answer
Postgresql default value boolean
SQL
5 votes278 views4 answers
Restart the psql server windows
SQL
0 vote272 views1 answer
Rename constraint postgresql
SQL
18 votes264 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote285 views2 answers
How to take recent row without limit in mysql
SQL