Help with SQL statement please

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Print On Demand

    Help with SQL statement please

    Hi All,

    We are transfering our newsletter list from a manual system into a
    more automated one. I'm trying to add a list of names and email
    addresses into a database table. The problem I'm having is the table
    has a field with an MD5 value for email_id. The MD5 is a hash of the
    email address.

    Can someone help with the SQL statement? This is what we're working
    from:

    INSERT INTO newsletter_emai l (email_id, email_name, email_address)
    VALUES
    ("email_id", "email_name ", "email_address" )

    email_id needs to be a MD5 of email_address

    Thank you for your help.

    Nigel,

    info @ ebookstand.com
Working...