/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 vote277 views1 answer
Import mysql'
SQL
1 vote324 views2 answers
Postgresql check privileges on schema
SQL
0 vote315 views1 answer
Sql delete caracter list
SQL
3 votes290 views1 answer
Sql multi column index performance
SQL
7 votes323 views2 answers
Mysql check db size
SQL
1 vote323 views1 answer
Drop primary key oracle
SQL
5 votes345 views2 answers
How to ascending order in sql
SQL
0 vote308 views1 answer
Varchar2 length in oracle
SQL
15 votes311 views3 answers
Postgresql change column type
SQL
13 votes321 views2 answers
Oracle select into and inner join
SQL