/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

7 votes234 views2 answers
Create index mysql cli
SQL
0 vote181 views1 answer
Insert or update cassandra
SQL
0 vote189 views1 answer
Drop CHECK constraint sql
SQL
1 vote247 views1 answer
How to get alternate records from a table in sql
SQL
1 vote197 views3 answers
Rows, INSERT INTO
SQL
9 votes205 views6 answers
Sql add column with default value
SQL
0 vote183 views1 answer
Openquery insert into linked server
SQL
0 vote208 views1 answer
SQL Where-Klausel
SQL
0 vote169 views1 answer
Oracle activate program
SQL
3 votes181 views1 answer
Oracle list dates without weekends
SQL