Use wildcard find and place segment of field in another field?

[TwilightRealm]

I'm wondering if it's possible to take part of a field information and insert it into another field?

I have a column called "idata" and some of the fields contain a segment of html data involving width="*px". It doesn't really say *, it's actually a number, but not every field has the same number.

I'd like to be able to use a sort of wild card, and say find the 'width="*px"' in the idata column and then put just the number in another field called in the imgwidth column, and replace the former number in idata with ''?

Is this possible? Otherwise I have to go through 550 rows, one at a time.

[masterofollies]

You could use LIKE % check for it.

[TwilightRealm]

Can that work in a replace statement? To say find where like 'width="%"' and insert % into another field?

[Inigoesdr]

No, you can't use backreferences with replace. What you could do is loop through the rows, match/replace your string with a regular expression(preg_replace()), and update the row.

[TwilightRealm]

Forgetting the wild card stuff, how would I go about saying 'find the phrase ("Created by Gareth") in this field, and insert ("Gareth") into another field'?

Nevermind, I remembered an UPDATE command can do this.