How to remove leading and trailing slashes in mysql

Question

I need to request removal / from url fields in table menu

original table

menuname url
home     /home/
about    /home/about/

demand

menuname   url
home       home
about      home/about

+5

user1414880 Jun 01 '12 at 3:24

3 answers

Here's how you remove trailing slashes from a field:

UPDATE `table_name` SET `field_name`=TRIM(TRAILING '/' FROM `field_name`)

+7

michal Sep 09 '13 at 18:11

Example:

SELECT TRIM(BOTH '/' FROM home, about) FROM 'table_name';

+3

ub3rst4r Jun 01 '12 at 3:30

sumit · Accepted Answer · 2012-06-01T03:26:18+0000

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

EDIT

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