/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 vote245 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
0 vote231 views1 answer
Get who is hired in january in sql
SQL
1 vote240 views1 answer
Drop df constraint sql server
SQL
0 vote239 views1 answer
Mysql query problems and solutions
SQL
0 vote241 views1 answer
<sql:datasource var="Snapsho"
SQL
1 vote237 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
2 votes224 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote249 views1 answer
Sql update subtract value
SQL
0 vote262 views4 answers
Sql rownum
SQL
7 votes239 views1 answer
Set sequence value oracle
SQL