how to remove leading and trailing slash in mysql

mysql, sql, trim

Solution

SELECT TRIM( BOTH  '/'    FROM  '/bar/' )

EDIT

SELECT TRIM(BOTH  '/' FROM link ) FROM menu

Problem

I need to query remove / from url fields in the table menu original table ``` menuname url home /home/ about /home/about/ ``` requirement ``` menuname url home home about home/about ```

Original source