/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 vote283 views1 answer
Mysql update table from select on another table
SQL
0 vote285 views1 answer
PSQL qith variables
SQL
-1 vote274 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
0 vote281 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
0 vote328 views1 answer
Traccar mysql
SQL
18 votes280 views6 answers
Drop table if exists
SQL
4 votes272 views1 answer
Select nls_date_format
SQL
1 vote280 views3 answers
Mysql disable foreign keys check
SQL
0 vote324 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote301 views1 answer
Mysql cli output to a file
SQL