how would you write this sql query correctly

[kevinkhan]

how do i write the Where clause in this query correctly

 

INSERT
  INTO cork_corkdesigns.friend_req
     (user,
     profilelink,
     status,
     pageScraped,
     messageStatus,
     name,
     email,
     dateOfBirth,
     gender,
     hometown,
     college,
     mobilenum)
     
SELECT user,
       link,
       1,
       1,
       0,
       name, 
       email,
       dateOfBirth,
       gender,
       hometown,
       college,
       mobilenum
  FROM cork_birth.profile_list
WHERE links in cork_birth.profile_list not in cork_corkdesigns.friend_req 

 

also some of the email in cork_birth.profile_list are not formatted correctly and are stored like this durrus09 & #64;yahoo.co.uk. is there a way you can replace the '& #64;' with an @ symbol??

[fenway]

That's a php question related to entities.