/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 vote373 views1 answer
Get initials name in sql
SQL
15 votes349 views2 answers
Sql order by multiple columns
SQL
3 votes414 views6 answers
DB::table('users')->get();
SQL
3 votes389 views2 answers
How to open postgresql in windows
SQL
2 votes352 views2 answers
How to view created temporary tables in mysql
SQL
3 votes408 views3 answers
Mysql auto increment after delete
SQL
0 vote344 views1 answer
Mysql begin statement
SQL
1 vote328 views1 answer
Select not matching data from two tables
SQL
14 votes365 views4 answers
Remove record from table sql
SQL
0 vote346 views1 answer
Check psql validity function
SQL