Heres what I am doing and I am trying to cut back on some steps here.. I have table_all_combine I then have table_hair_info >> then colors I want to take colors column and put it in the colors_1 column in table combine I keep getting stuck where colors have a dash in them like >> 88-99 I then want to take another table and add in rest of colors from description etc to table_combine_all Anyone know of any easy way of doing this? Or is there some tutorial somewhere on the web that shows you how to do this? Anyway of doing this with mysql workbench or some other easy program? Heres the code I was using insertinto tablename (col1_name)select(col2_name)from tablename; I'm not sure why it was splitting the data....???