/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 vote219 views1 answer
How to use sqlcommand
SQL
1 vote162 views1 answer
DATE_SUB postgres
SQL
1 vote209 views1 answer
Concat first name and last name in mysql
SQL
0 vote175 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
0 vote128 views1 answer
Mysql offset from bottom
SQL
6 votes182 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
25 votes179 views6 answers
How to change column name in mysql
SQL
0 vote235 views1 answer
Oracle convert int to date
SQL
5 votes182 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
0 vote195 views1 answer
Databricks install odbc driver connect to sql server
SQL