How to match and categories mysql data in the background?

I was researching about this but couldn't find any tutorial as I don't know what exactly the program is used in this matter.

I have mysql data of expenses. What I want is after user add new expense, it automatically categories that transaction based on the supplier name or the description provided.

For example if the transaction is: Supplier/Store: Mc Donalds Date: 15/06/2016 Amt: $10.00 Tax: $1.00

Then column "Category" should automatically be filled by "Food" may be sometime later in the background.

Hope you can give me a kick start.

Thanks