need an easy way to do this

[itworks]

i have a table in a mysql database with 712 regists.

in one of the columns called "page" i have the page name that corresponds to each of the regists, like for example "paga_name.htm".

the problem is that i've implemented a php script in all those pages and now they are no longer htm pages, they are php pages, is there an easy mysql command to change the regists in the page column from "blablabla.htm" to "blablabla.php" without having to change one at a time?

thanks in advance.

[nnichols]

UPDATE regists SET page = REPLACE(page, ".htm", ".php");

Haven't tried it but it should work ok 😉

test it on a sample first

[itworks]

thanks nnichols!

i had to change it to:
UPDATE movies SET page = REPLACE(page, ".htm", ".php");
'cause my table name was MOVIES and it did work.

thanks a lot you've saved me a lot of work.

😉