gaviel

up

what will happen to the ID then which is the primary key ?! wouldn't it affect the ID's? and addition to my post above to be more clearer ..

thanks for the response .. Tried it and work real nice fast .. but the problem is, not only the string "VALUES ({$int_here}, " got replace .. with some fields that has an instance of 5, 4, 3, 2, 1 got replace too .. E.G .. INSERT INTO `subjects` VALUES (5, 'some text here', 'some text here with 5, 4, 3, 2, 1', 'some text here'); any solutions?

I wanted to replace a strings in a large text file .. what would be the fastest way ?! e.g the text file contains .. INSERT INTO `subjects` VALUES (1, 'some text here', 'some text here', 'some text here'); INSERT INTO `subjects` VALUES (2, 'some text here', 'some text here', 'some text here'); INSERT INTO `subjects` VALUES (3, 'some text here', 'some text here', 'some text here'); INSERT INTO `subjects` VALUES (4, 'some text here', 'some text here', 'some text here'); INSERT INTO `subjects` VALUES (5, 'some text here', 'some text here', 'some text here'); I wanted to replace the string " VALUES (1, " with "VALUES (" in each line .. I'm new in PHP so any response would be much appreciated .. thanks