/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 vote135 views1 answer
How to combine rows in sql server procedure
SQL
0 vote134 views1 answer
MySQL import data from large CSV file
SQL
0 vote116 views1 answer
Mod in sql
SQL
0 vote122 views1 answer
Setval postgres example table id
SQL
16 votes122 views2 answers
Add column if not exists mysql
SQL
0 vote124 views1 answer
Plsql check for string in numeric
SQL
1 vote113 views2 answers
Install mysqldump ubuntu
SQL
0 vote114 views1 answer
Select a row include list of array with join table SQL
SQL
0 vote111 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
36 votes108 views3 answers
Finding duplicate column values in table with sql
SQL