/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 vote134 views1 answer
Mysql isshow
SQL
0 vote166 views1 answer
What is default mysql database password in linux
SQL
0 vote153 views1 answer
Psql show db
SQL
0 vote160 views1 answer
Delete a record from a table sqlite3
SQL
0 vote99 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote141 views1 answer
Sql quary intervewi question
SQL
3 votes140 views1 answer
Créer une table sql
SQL
26 votes142 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote148 views1 answer
SQL add a totals of differemt rows of the same id
SQL
0 vote152 views1 answer
Compare two tables to find unmatched records
SQL