Changing MySQL field entries using a wildcard
Posted: Sun Jul 24, 2005 11:18 am
Hi there,
I need to update about 500 or more rows in a table.
Specifically I need to change the file extension from .htm to .php in a specific field but am not sure how to do it.
Is there an update command that can wildcard this? eg,
or if that's not the right way to wildcard, what is?
Cheers,
Bes.
I need to update about 500 or more rows in a table.
Specifically I need to change the file extension from .htm to .php in a specific field but am not sure how to do it.
Is there an update command that can wildcard this? eg,
Code: Select all
UPDATE table SET fieldx like '*.php' WHERE fieldx like '*.htm'Cheers,
Bes.