/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 votes389 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote379 views1 answer
Order child below the parent in mysqli
SQL
0 vote361 views2 answers
Oracle ora-00054 how to unlock
SQL
-1 vote350 views1 answer
How to switch user in mysql
SQL
2 votes363 views1 answer
Oracle sql merge
SQL
0 vote358 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote356 views1 answer
Delete duplicate rows
SQL
2 votes349 views2 answers
Mysql user access to database
SQL
3 votes357 views2 answers
Update Query in SQL Server
SQL
1 vote344 views1 answer
Sample clause in sql
SQL