/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 vote139 views1 answer
Sql select where id not exists in another table
SQL
0 vote174 views1 answer
Postgres docs /copy metacomand
SQL
1 vote148 views1 answer
Describe table in sql
SQL
2 votes132 views1 answer
SELECT INTO
SQL
2 votes154 views1 answer
Sql count having
SQL
5 votes135 views5 answers
Find max number in sql
SQL
0 vote158 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote140 views1 answer
T-sql update table variale
SQL
6 votes127 views2 answers
How to copy data in sql
SQL
0 vote145 views1 answer
Providername system.data. mysql
SQL