/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 vote224 views1 answer
Select row with latest date mysql
SQL
0 vote218 views2 answers
How to generate a unique random number in mysql
SQL
0 vote215 views1 answer
Unique index in mysql
SQL
1 vote214 views1 answer
Oracle user last connection date
SQL
1 vote213 views1 answer
Add constraint sql
SQL
3 votes228 views1 answer
Locate sql server
SQL
0 vote224 views1 answer
Sqlalchemy get schema from database
SQL
4 votes212 views1 answer
Sql any
SQL
5 votes236 views1 answer
Dbms_metadata.get_ddl table
SQL
103 votes338 views2 answers
Sql server LIKE '%%'
SQL