/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 vote128 views2 answers
Connect to mysql server mac terminal
SQL
0 vote126 views1 answer
Install postgresql 12 on debian 10
SQL
1 vote139 views1 answer
Mysql datetime with timezone offset
SQL
0 vote149 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote119 views1 answer
To change the database owner in SQL server
SQL
0 vote119 views1 answer
Get enginge db mysql
SQL
4 votes131 views2 answers
Linq join
SQL
6 votes135 views2 answers
Install psql mac
SQL
3 votes123 views1 answer
Only join in sql
SQL
4 votes110 views1 answer
Mac install mysql
SQL