/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

9 votes223 views3 answers
Where clause sql
SQL
0 vote289 views8 answers
Sql to c# linq converter online
SQL
0 vote186 views1 answer
Edit a field mysql terminal
SQL
3 votes325 views4 answers
Sql interview questions
SQL
0 vote204 views1 answer
Find number of entries sql
SQL
0 vote222 views1 answer
Pgadmin check database
SQL
0 vote235 views1 answer
Create table split string function in sql server
SQL
12 votes203 views2 answers
Delete entries in postgresql
SQL
0 vote206 views2 answers
Py sqlite if entry exists
SQL
0 vote211 views1 answer
Implicit inner join table alias
SQL