Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by henrik1782

  1. henrik1782

    Update table to set country (LAND in example) based on e-mail endings.

    Thanks for all your help. It just worked like a charm. Found the list with all cctld's http://www.iana.org/domains/root/db/ and this actually requere more than 2 chars to put in all, but for my needs it is ok.
  2. henrik1782

    Update table to set country (LAND in example) based on e-mail endings.

    Thanks a lot. I really appreciate and will give it a shot when I get home. Best regards Henrik
  3. henrik1782

    Update table to set country (LAND in example) based on e-mail endings.

    I use this MySQL list to update the Country (LAND) based on e-mail endings, but it will search the entire table each time. Isen't there a more effective way to do this? UPDATE `Bruger_data` SET `LAND` = "Denmark" WHERE `EMAIL` LIKE '%.dk' AND `LAND` = "Not set"; UPDATE `Bruger_data` SET `LAND`...
See more

Part and Inventory Search

Back
Top