/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 vote311 views1 answer
Sql period overlap
SQL
0 vote321 views1 answer
Closure in sql
SQL
6 votes308 views2 answers
Drop foreign key
SQL
0 vote318 views3 answers
Select random sql
SQL
0 vote311 views1 answer
ORA-00942
SQL
2 votes347 views1 answer
Pdo mysql insert
SQL
0 vote306 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
2 votes307 views1 answer
Oracle list grants on package
SQL
0 vote338 views1 answer
T-sql delete view if exists
SQL
0 vote300 views1 answer
Oracle synonym procedure
SQL