/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 votes330 views1 answer
Mysql ip address data type
SQL
0 vote338 views1 answer
Oracle tablespace autoextend
SQL
-1 vote321 views1 answer
Sql set max value in column
SQL
0 vote309 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
0 vote307 views1 answer
Sql query with date
SQL
20 votes352 views6 answers
Change password in mysql
SQL
10 votes343 views4 answers
Primary key in sql
SQL
0 vote346 views1 answer
Mysql equivalent decode oracle
SQL
5 votes339 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
0 vote329 views1 answer
Get create sql of hibernqte entity
SQL