Help with PHPMyadmin for Joomla

Discussion in 'Joomla Support' started by titanium, May 16, 2014.

Thread Status:
Not open for further replies.
  1. titanium

    titanium UKBF Regular Free Member

    242 31
    Hello
    I would like to run a mysql command which updates the metadata field in the table "content". I want to copy the data (authorship, basically) from one article and paste it into a command so that all my articles have the same authorship. I am about as good with phpmyadmin as I am at driving. I can turn the key and drive from A-B but please don't open the bonnet!

    Can anyone let me know the sql for this or even do a lmgtfy for me, as I can't seem to put it into terms that google can understand!

    Merci.
     
    Posted: May 16, 2014 By: titanium Member since: Mar 30, 2013
    #1
  2. ryedale

    ryedale Contributor Full Member - Verified Business

    1,547 368
    update xxx_content set metadata = 'your data'

    Replace 'xxx' with your table prefix and 'your data' with your copied data
     
    Posted: May 17, 2014 By: ryedale Member since: Dec 17, 2013
    #2
  3. titanium

    titanium UKBF Regular Free Member

    242 31
    Thanks - finally plucked up the courage to try this, and it worked (second time round, as I replaced 'your data' with my data the first time but got an error, then tried but with keeping the quotes.) THANKS!
     
    Posted: Jun 2, 2014 By: titanium Member since: Mar 30, 2013
    #3
  4. lynxus

    lynxus UKBF Ace Full Member

    1,327 318
    Lol.. Eeeek..

    Was reading this and waiting for the .." Erm, my site has stopped working now I entered that command. "
     
    Posted: Jun 2, 2014 By: lynxus Member since: Jul 5, 2011
    #4
  5. ryedale

    ryedale Contributor Full Member - Verified Business

    1,547 368
    NO problem, glad you got it sorted :)

    Just always back up before you run any queries in PHPMyAdmin :)
     
    Posted: Jun 2, 2014 By: ryedale Member since: Dec 17, 2013
    #5
Thread Status:
Not open for further replies.