/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

12 votes170 views6 answers
Change mysql root password
SQL
0 vote176 views1 answer
Mysql bind-address default value
SQL
0 vote173 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
0 vote190 views1 answer
Oracle plsql sleep
SQL
0 vote191 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
3 votes144 views5 answers
Mysql get last inserted id
SQL
0 vote145 views1 answer
Luu ckeditor vao mysql
SQL
7 votes166 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote145 views1 answer
Mysql default timestamp value to be current timestamp
SQL
0 vote163 views1 answer
Mariadb.service failed with result 'exit-code'
SQL