Help Request Extracting user titles via myphpadmin

Discussion in 'Site Help and Suggestions' started by assembler_EX, Jul 11, 2015.

  1. assembler_EX

    assembler_EX Administrator

    Joined:
    May 20, 2015
    Messages:
    268
    Likes Received:
    107
    I have the old database, but need to extract the fields "username" and "usertitle" from table: User

    Anyone know the query to run to extract the two into one file? Preferably with a "if empty" skip for empty user titles
     
    assembler_EX, Jul 11, 2015
    #1
  2. TriMesh

    TriMesh Site Supporter 2013-2016

    Joined:
    Jul 3, 2008
    Messages:
    1,490
    Likes Received:
    192
    CREATE TABLE userandtitle AS SELECT username, usertitle FROM User WHERE usertitle <> NULL

    Should do it.
     
    TriMesh, Jul 12, 2015
    #2
  3. retro

    retro Administrator Staff Member

    Joined:
    Mar 13, 2004
    Messages:
    10,336
    Likes Received:
    311
    The query I gave you works ;)
     
    retro, Jul 17, 2015
    #3

Share This Page