/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

6 votes175 views2 answers
Oracle undotbs usage
SQL
0 vote129 views2 answers
Spring properties file for db
SQL
0 vote180 views1 answer
Mysql url data type
SQL
0 vote204 views1 answer
How to input data as id in database sql c#
SQL
0 vote172 views4 answers
Sql rownum
SQL
0 vote183 views2 answers
Reseed sql identity
SQL
8 votes209 views4 answers
Convert date to dd/mm/yyyy sql
SQL
0 vote169 views1 answer
Postgres declare variable
SQL
5 votes169 views2 answers
Oracle tables with column name
SQL
4 votes164 views1 answer
What are the data types in sql
SQL