/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

11 votes178 views1 answer
Creating tables in sql with python
SQL
1 vote211 views1 answer
Mysql print variable
SQL
4 votes167 views2 answers
Linq join
SQL
5 votes178 views1 answer
Oracle get foreign keys on table
SQL
0 vote260 views1 answer
ORA-00942
SQL
13 votes177 views2 answers
Get date from now() mysql
SQL
0 vote178 views1 answer
Select sql in descending order
SQL
24 votes185 views5 answers
List mysql users
SQL
3 votes177 views2 answers
Sql get month name
SQL
1 vote198 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL