/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 vote115 views1 answer
Renommer base sql
SQL
9 votes112 views6 answers
Sql add column with default value
SQL
1 vote101 views2 answers
String to date postgres
SQL
7 votes101 views1 answer
Postgres base size
SQL
-1 vote101 views5 answers
Not in sql
SQL
0 vote110 views1 answer
How to join result table in mysql
SQL
0 vote120 views2 answers
Amazon linux postgresql client
SQL
0 vote104 views7 answers
Les jointures sql server
SQL
2 votes105 views1 answer
Sql column values comma separated
SQL
0 vote65 views1 answer
How to check oracle index table
SQL