/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

2 votes329 views1 answer
Cast string to datetime mysql
SQL
0 vote644 views1 answer
Create pl/sql stored procedure
SQL
2 votes339 views1 answer
Merge firstname and lastname in sql oracle
SQL
1 vote320 views1 answer
Rename table column name in mysql
SQL
0 vote337 views1 answer
Sql today at midnight
SQL
0 vote298 views1 answer
Replace sqlalchemy
SQL
0 vote314 views1 answer
MySQL get all previous date record
SQL
0 vote303 views1 answer
Order by monthly in sql
SQL
0 vote383 views1 answer
Reindexing all tables sql server
SQL
0 vote316 views1 answer
Mysql foreach insert
SQL