/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 vote146 views1 answer
Greater than or equal to symbol in postgres
SQL
0 vote185 views1 answer
Sql alter column name sql server
SQL
0 vote141 views1 answer
Myswql show full processlist
SQL
0 vote161 views1 answer
Search In the Data using ObjectName
SQL
4 votes163 views3 answers
Drop Table Oracle
SQL
0 vote158 views1 answer
Laravel migration sql dump
SQL
0 vote143 views1 answer
Timestamp(0) postgresql
SQL
0 vote169 views1 answer
Pgadmin check database
SQL
1 vote153 views1 answer
Oracle duration between timestamps
SQL
0 vote149 views1 answer
Write sql query to show the details start from digit
SQL