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.