Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bill79
Starting Member
13 Posts |
 Posted - 2010-08-26 : 15:36:47
|
| Hi all,Just wondering if someone can assist me with the following issue.I have a database in MySQL and I'm using PHPMyAdmin to interact with the database.So within the table example_table_name I have two columns product_item_short and product_item_long which have URL's in them. Now there is 3000 rows of data and as an example the URL in each start data/image/someimage.png.In both columns I need to remove the data/ and I would like to know how I could so this in SQL.Many thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-26 : 15:39:04
|
| http://dev.mysql.com/doc/refman/5.0/en/string-functions.htmlyou want the replace() function.by the way, this is a Microsoft SQL Server Forum. Might have better luck in general for mysql questions on a mySQL forum. |
 |
|
|
bill79
Starting Member
13 Posts |
Posted - 2010-08-26 : 15:43:05
|
| Hi,Yes, I have resolved that with the SUBSTR() function.Thanks |
|
|
|
|
|
|
Edit text in columns