Member Avatar for teedoff

Hi, ok I have about 1600 records in a mySQL db. Many of them have a forward slash "/" in the itemName column. In my site, I am passing the itemName as a URL variable on many search forms, so obviously the forward slash is not a good naming convention to use.

IS there a way to go in my db and find and replace all instances on the forward slash? I usually use navicat for db management, and it has a find feature, but you have to replace each forward slash it finds by hand. Thanks for any suggestions in advance!

  • 3 Contributors
  • 4 Replies
  • 140 Views
  • 2 Years Discussion Span
  • Latest Post Latest Post by BASHA`

Recommended Answers

All 4 Replies

Member Avatar for d5e5

For a table named 'items':

update items set itemName = replace(itemName,'/','');
Member Avatar for teedoff

Awesome! This will only replace the "/" in the column I specify correct? What I mean is there are forward slashes in other columns, but since they are not used in variables I might pass in a url, I want to leave them. Thanks!

Member Avatar for d5e5

Yes, it replaces only the specified string in the specified column. Forward slashes in other columns won't change.

Member Avatar for BASHA` 
                        THANK U
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.