ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Exporting a single MySQL field

August 04, 2007 2:00am

Subscribe [2]
  • #1 / Aug 04, 2007 2:00am

    sedated

    7 posts

    Hey folks.

    I am not much a database person so I am not sure if this is at all possible.

    I have a customer database that I want to only export a single field…maybe two.  We are migrating from our online store’s newsletter system to Campaign Monitor so I need to export all the email addresses but I can’t seem to figure out how to export just that one field using phpmyadmin.

    Does anyone have ideas as to how I might be able to do something like that?

    Any help would be great.

    Thanks!

  • #2 / Aug 04, 2007 9:15am

    Ingmar

    29245 posts

    A simple SQL query:

    SELECT fieldname FROM `databasename`

    Replace fieldname and databasename with your values.

  • #3 / Aug 07, 2007 6:27pm

    sedated

    7 posts

    Figured it was sometime simple.  That did it.

    Thanks!

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases