/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

8 votes142 views1 answer
Oracle create datafile
SQL
4 votes134 views1 answer
Datepart postgres
SQL
1 vote127 views1 answer
Sql alchemy with azuresql server
SQL
1 vote140 views1 answer
Mariadb case switch
SQL
-1 vote172 views1 answer
Sql show custom constraints
SQL
0 vote149 views1 answer
Systems sql
SQL
1 vote129 views1 answer
Tsql random number
SQL
0 vote148 views1 answer
Sql server beginning of month
SQL
0 vote156 views1 answer
Recently updated stored procedure in sql server
SQL
0 vote135 views1 answer
Sauvegarde complète my sql
SQL