/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

1 vote337 views1 answer
How to update date add hours in postgresql
SQL
5 votes328 views3 answers
Mysql extract month from date
SQL
-3 votes362 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
2 votes379 views1 answer
Python sql
SQL
1 vote343 views3 answers
How to get date in sql
SQL
0 vote370 views1 answer
Define a variable in mysql from select
SQL
1 vote367 views2 answers
Sql server backup table
SQL
0 vote341 views1 answer
Tsql pad left
SQL
0 vote336 views1 answer
Postgresql array to rows
SQL
0 vote323 views1 answer
How to check if there is no database schema
SQL