/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

4 votes202 views1 answer
Wildcard in sql
SQL
0 vote238 views1 answer
Mysql record group by created date count
SQL
16 votes211 views4 answers
Mysql import from sql file
SQL
0 vote209 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
11 votes217 views2 answers
Having clause in sql
SQL
10 votes206 views3 answers
Join multiple tables sql
SQL
0 vote221 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote193 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
0 vote207 views1 answer
Mysql check if lowercase
SQL
12 votes207 views5 answers
Sql merge
SQL