/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

11 votes275 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote290 views1 answer
Drop a view in sqlite
SQL
0 vote246 views1 answer
Copied text from internet not inserting in mysql
SQL
1 vote257 views1 answer
Access the postgres psql
SQL
15 votes256 views6 answers
Psql
SQL
4 votes254 views2 answers
Xampp mysql database server is not starting mac m1
SQL
0 vote250 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote295 views1 answer
How to check rollback status in oracle
SQL
5 votes260 views2 answers
Oracle list columns schema
SQL
0 vote271 views1 answer
Sparql if bound query
SQL