I'm trying to use concat to bring two strings together in one column using MySql. It's working fine, but I'd like to insert a comma between the fields and I'm not sure how to do that.
Here is what I have
select concat(city,state) as location from address_table
The result is something like this
What I want the result to look like is
Can someone help out with that please?