Query Request
 

This isn't really a hack request, but I couldn't decide on which forum would be the most appropriate, but as this is a "request", I stuck it in here. :nervous:

Many of my members have "http://www./" entered as their homepage. I'm not sure why, but to prevent future instances I have installed N9ne's "default homepage" hack.

However, for those members that have already registered, the value hasn't changed, obviously. Is there a way to run an UPDATE query or something in phpmyadmin that will allow all the values of "http://www./" changed to "http://www.mydefaultsite.com"?

:rambo: Thanks in advance!

php forum would have been right ;)

[sql]UPDATE user SET homepage='http://www.mydefaultsite.com' WHERE homepage='http://www./'[/sql]

Interestingly enough, I was in the PHP forum first. *hehe* :$

edited to say - Nevermind. Dunno what the error was that I originally got, but I've got it fixeded up. ;) But, the query didn't seem to have any effect on the current homepages.

the query has an effect, but you have to be sure that the hompage is exactly like that.

is the last / really there?

if not use this:

[sql]UPDATE user SET homepage='http://www.mydefaultsite.com' WHERE homepage='http://www.'
[/sql]

There we go. That did the trick. :D

The last "/" was showing up when I did a mouseover the button and when I clicked "properties" on it, too. :s But whether real or no, this worked! Thanks a million. :D

:)
you're welcome :)