Let磗 say I have a column with diffrent html pages and identical imagerefs in it:
---html---
<img src=http://www.phpbuilder.com/board/archive/index.php/"images/pic1.gif" height=31 width=224 border=0>
---other html---
Can it be done to change only a part of the text in many rows, for example'heigth=31' to 'heigth=45' without having to update everything in the field.
I磛e tried with "UPDATE table SET table_col=REPLACE(table_col,'heigth=31','heigth=45')" but the REPLACE-functions seem only to work with one character in 'from-str'
/christian
---html---
<img src=http://www.phpbuilder.com/board/archive/index.php/"images/pic1.gif" height=31 width=224 border=0>
---other html---
Can it be done to change only a part of the text in many rows, for example'heigth=31' to 'heigth=45' without having to update everything in the field.
I磛e tried with "UPDATE table SET table_col=REPLACE(table_col,'heigth=31','heigth=45')" but the REPLACE-functions seem only to work with one character in 'from-str'
/christian