/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 vote138 views1 answer
Postgres convert exisiting column to text
SQL
-1 vote143 views2 answers
Create temporary table sql
SQL
0 vote127 views1 answer
Syntax for changing column size in mysql
SQL
6 votes162 views1 answer
Postgresql get year
SQL
6 votes147 views4 answers
Mysql get random row
SQL
0 vote134 views1 answer
Soql update query
SQL
14 votes138 views2 answers
Oracle add attribute to table
SQL
4 votes136 views2 answers
Show all database inside postgresql
SQL
0 vote158 views1 answer
In query in sql
SQL
0 vote131 views1 answer
Print boolean in plsql
SQL