September 24th, 2012, 10:49 AM
Sql query to alter value. Help me write this please?
So here is the short.
I have an sql table
inside this particular table are columns and one of them is called
I need to edit the value of this column from whatever it is
to read "mydomain.com"
The reason i put from whatever it is
is because the value currently can be 3 or 4 different things.
I am looking for a way to edit this specific column value no matter what it reads, to be changed to "mydomain.com"
Currently it appears 15,000 times in the database and its messing up certain user functions in my CMS
September 24th, 2012, 10:57 AM
UPDATE my_table SET my_column = 'something';
September 24th, 2012, 02:26 PM
ok in that case it would mean
i need to goto that specific table
when it loads in phpMYadmin i click Browse if not there already
and then click Query to run:
UPDATE *_community_access_log SET domain = 'the domain i want';
and in this case " * " would equal my table prefix
September 24th, 2012, 06:37 PM
yo will just NOT believe this
i ran a search for the alternate link that is showing up in domain
i then ran the sql query to edit it
it ran fine
all referances were gone
but then i waited a few minutes and its all back again
it keep coming up on its own