php - Generate Lat / Lon from addresses in mySQL table -

I currently have a MySQL table of addresses in some places for which I need to get latitude and longitude. There is a table that is being used to map Google Maps store stores in WordPress. I am looking for the best way to get latitude / lawn for all records in this database.

Does anyone know a simple strategy that I can use to run through all the records and to get the latitude / loan of each address?

Google has a Geocoding API -