Filter database with list from a text file

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • eldorado
    New Member
    • Jul 2011
    • 1

    Filter database with list from a text file

    I have a large list of email addresses "on other server" that I have found are undeliverable to users"unsubscri ber email", I want to mark a field in mysql to 1 where there is this email address???
    I'm trying this

    update user set styleid = 1 where email =
    load_File('//ip add/email.txt')

    but it dose not work
    Please is there any Answer
    Last edited by Niheel; Jul 15 '11, 09:24 PM. Reason: please don't bold the whole question
  • mwasif
    Recognized Expert Contributor
    • Jul 2006
    • 802

    #2
    Use LOAD DATA INFILE to import the contents of file to a table and then update the respective table with a JOIN.

    Comment

    Working...