Copy field value

This topic contains 3 replies, has 2 voices, and was last updated by  Alex Rollin 4 years, 8 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • September 16, 2019 at 9:59 pm #508509

    sinaxi
    Free User
    Post count: 134

    I’ve a custom field named product_code (text)…. after I created another custom field (integer) named sort_value

    I’d like to copy all values from product_code to sort_value.

    Is there a query that I can run automatically in PhpMySql.
    Could be that I’ll lose some values when I copy from text to integer but most values will be OK and I’ll work only on missed records.

    Thanks

    September 16, 2019 at 11:11 pm #508527

    Alex Rollin
    Moderator
    Post count: 27815

    You can do that by exporting the listings, editing the CSV file with Libre or Open office, and then re-importing the listings.

    https://wpgeodirectory.com/docs-v2/geodirectory/settings/import-export/

    September 16, 2019 at 11:21 pm #508530

    sinaxi
    Free User
    Post count: 134

    Can I do live on table??

    September 16, 2019 at 11:33 pm #508533

    Alex Rollin
    Moderator
    Post count: 27815

    We don’t provide support for direct edits to the database.

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket