/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 vote179 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote156 views1 answer
Sql runnignsum
SQL
0 vote129 views1 answer
Microsoft sql server management studio clear cache
SQL
2 votes168 views1 answer
Create table with primary key
SQL
0 vote216 views1 answer
Sql create and grant user access to database
SQL
1 vote196 views1 answer
Isnull sql server
SQL
0 vote185 views1 answer
Mysql default uuid
SQL
0 vote263 views2 answers
Sqlalchemy default value for column
SQL
0 vote198 views1 answer
Sql missing values
SQL
0 vote182 views1 answer
SQL SELECT-Klausel
SQL