OK thanks for the help now,, if me used SET field1 = SUBSTRING(@f1, LOCATE('name=', @f1)+5), field2 = SUBSTRING(@f2, LOCATE('age=', @f2)+4), field3 = SUBSTRING(@f3, LOCATE('hoby=', @f3)+5) it's coment for the name and number of columns remain, when this names and numbers column varied? what should i do,,,
–
luqmanulNov 30 '12 at 19:34

I could not understand you. Would you give an example?
–
shiplu.mokadd.imDec 1 '12 at 10:42

i want to delete before "=" with LOAD DATA, so only one step,, :)
–
luqmanulDec 3 '12 at 2:52