Wonderful. We look forward to having a new South Carolinian. That said given you are moving from MS you won't find to much of an adjustment. The main areas in Columbia are Northeast, Southeast, Irmo, and Lexington. Definitely look at the school districts to help make your decision in addition to your desired lifestyle. As you know every area has more and less appealing sections. Contact a local agent and talk a bit about your needs and wants. When you purchase you want to find a home with great market value as well as room to grow. An agent can even help you find a home to rent if that is your desire.
You'll have to get used to the difference in our barbeque style. We have a mustard based sauce.
--Welcome and good luck!