mySQL find and replace extension?

[johno69]

I have a table called 'urltech' in a mySQL database. I store urls's like this: 'data/name_data.htm' - I just need to change all the extensions from '.htm. to '.pdf'.
Any ideas?

 

[piti]

i have not used that yet but try
update urltech set columnname = REPLACE(columnname, 'htm', 'pdf')

 

[Fiendy]

As Piti says, this will work, I've done it myself, although I would use ".htm" & ".pdf" in the REPLACE statement otherwise, it may replace any occurrence of the letters "htm" in your data, not just the extensions.

Mark.

 

[piti]

well you're right, i was not thinking about that, i just wrote down a sample code for replacing strings

btw - what about a link with filename "data.htm.htm" ;-)))

 

[Fiendy]

> btw - what about a link with filename "data.htm.htm"
LOL
I think that's then a job for good ol' Perl then