mysql remove first and last character from string

Solutions on MaxInterview for mysql remove first and last character from string by the best coders in the world

showing results for - "mysql remove first and last character from string"

1/* remove any first & last character in mysql*/
2SELECT substring(myfield,2, length(myfield)-2) FROM mytable;

1SELECT TRIM(BOTH ',' FROM name) from users; /*trim leading and trailing ,*/
2SELECT TRIM(LEADING ',' FROM name) from users;/*trim leading,*/
3SELECT TRIM(TRAILING ',' FROM name) from users; /*trim trailing,*/

similar questions

mysql remove last character mysql delete last row mysql remove last empty newline sql remove last x char sql remove first character from string mysql query first character select first and last row mysql select first character of string mysql sql remove last 2 digit how to remove characters from string in mysql

queries leading to this page

mysql remove first and last character mysql remove first character from string mysql remove first and last character from string remove string from first string mysql remove letter 2b from first string mysql mysql remove first and last character from string