MySQL string replace

Question

Hey, what's the most effective way to remove beginning and ending slashes from all rows in a particular column using MySQL?

Before:

/hello/world/
foo/bar/
/something/else
/one/more/*

After:

hello/world
foo/bar
something/else
one/more/*

...or maybe this should be done in PHP instead?

raspi · Accepted Answer · 2009-05-28 02:43:52Z

3

See TRIM()

UPDATE MY_TABLE SET my_field=TRIM(BOTH '/' FROM my_field);

answered May 28, 2009 at 2:43

raspi

6,1423 gold badges36 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andrew Hare · Accepted Answer · 2009-05-28 02:37:42Z

1

You could definitelyt make this work using the MySQL string functions but I think this would be best handled outside of the database using PHP or whatever programming language of your choice.

answered May 28, 2009 at 2:37

Andrew Hare

353k75 gold badges649 silver badges642 bronze badges

Comments

Jrgns · Accepted Answer · 2009-05-28 02:45:18Z

1

Your PHP option: (I'm assuming the fetched row is in $row)

$row['Field'] = explode('/', $row['Field']);
//Remove the empty elements
$row['Field'] = array_filter($row['Field']);
$row['Field'] = implode('/', $row['Field']);

answered May 28, 2009 at 2:45

Jrgns

25.3k19 gold badges74 silver badges77 bronze badges

1 Comment

raspi Over a year ago

No need for array. $row['Field'] = trim($row['Field'], '/'); should do the trick.

Collectives™ on Stack Overflow

MySQL string replace

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related