/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

0 vote347 views1 answer
List all permissions on a table in postgres
SQL
2 votes350 views1 answer
Use cases condition in sql query laravel
SQL
16 votes351 views3 answers
Update table from another table
SQL
0 vote311 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote359 views2 answers
Get item by composite primary key mysql
SQL
3 votes344 views2 answers
Postgres inner join vs join
SQL
0 vote336 views1 answer
Create relationship with betwen two tables in postgersql
SQL
2 votes317 views2 answers
Join update query in sql
SQL
0 vote313 views1 answer
Find number of entries sql
SQL
1 vote329 views1 answer
Count mysql server db tables
SQL