/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 vote282 views2 answers
How to use aggregate functions in sql
SQL
-2 votes299 views1 answer
How-to-remove-mysql-root-password
SQL
12 votes264 views3 answers
Duplicate a column in sql
SQL
1 vote304 views1 answer
Sql set auto increment back to 0
SQL
2 votes282 views1 answer
Oracle list grants on package
SQL
2 votes308 views2 answers
Mysql write into table
SQL
0 vote283 views1 answer
Sql list dates between two dates
SQL
0 vote272 views1 answer
Sql server cannot create database diagram
SQL
0 vote264 views2 answers
Change database postgres
SQL
2 votes294 views1 answer
Search query in mysql
SQL