/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 vote100 views1 answer
C# add a textbox in mysql select
SQL
0 vote93 views2 answers
Soql last year
SQL
0 vote95 views1 answer
Hibernate xml property MySQL url, username and password
SQL
3 votes113 views2 answers
How to open postgresql in windows
SQL
0 vote102 views1 answer
Why mysql is used?
SQL
0 vote117 views2 answers
Mysql dump structure only
SQL
2 votes96 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote107 views1 answer
Split string by comma in sql server
SQL
0 vote97 views1 answer
Postgresql import data from csv
SQL
4 votes114 views2 answers
Bulk kill mysql processlist
SQL