Phil,

=) sorry, thanks I will give it a shot.

Beyond new here in this, my buddy tossed me his MySQL book "The Language of SQL" and said read.

Thank you again... also...

Phil,

that looks like it would work for data you give to the statement itself.

I'm looking to go through close to 6 million records in leadsdb.leads

not manually do it

ET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for leads

-- ----------------------------

DROP TABLE IF EXISTS `leads`;

CREATE TABLE `leads` (

`ID` int(11) NOT NULL AUTO_INCREMENT,

`phone_number` varchar(255) DEFAULT NULL,

`first_name` varchar(255) DEFAULT...