/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 vote125 views1 answer
Show the colums of table sql
SQL
0 vote117 views1 answer
Mysql update sequence with order by
SQL
0 vote129 views1 answer
Min salary in sql
SQL
1 vote118 views1 answer
Ilike for date postgres
SQL
1 vote124 views1 answer
Sql server find tables referenced foreign key
SQL
0 vote132 views1 answer
Sql column contains special character
SQL
0 vote155 views1 answer
Add new column in sql with foreign key
SQL
0 vote143 views1 answer
SELECT statement to find the specific cell in database table
SQL
7 votes121 views3 answers
Postgresql dump and restore db
SQL
0 vote127 views1 answer
Mysql query with sql to get the next row
SQL