/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 votes217 views6 answers
In operator in sql
SQL
15 votes317 views3 answers
Postgresql change column type
SQL
1 vote181 views2 answers
Mysql: command not found
SQL
0 vote171 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote171 views1 answer
Sql server manager close connection
SQL
13 votes348 views4 answers
Sql joining 3 tables
SQL
0 vote199 views3 answers
How to assign custom id in mysql
SQL
0 vote183 views1 answer
Write a query to peint the pattern P(20)
SQL
3 votes181 views1 answer
Postgres count distinct
SQL
1 vote195 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL