how to count how many records of a field are in a databasehow to count how many records of a column are in your database and sort by the count
Use the select query below will produce a count on each variation in the field you require.
Simply change the fieldname to be your fieldname in the database and the tablename to the the name of the table
SELECT fieldname , COUNT( * ) AS counta FROM tablename GROUP BY fieldname ORDER BY counta DESC
CAN YOU HELP
Turbo Charge your businessWe put our money where our mouth is. Our mission is to help any business anywhere get back on track.
If we don't bring you new customers you pay us nothing. We take nothing up front and there is no contract. We trust you implicitly. And it is literally if you don't pay us for bringing in new customers, then we stop brining them in.
You decide how much you are willing to pay for a customer and you pay once we bring them to you.
Simple, easy nothing else to explain.
If you would like us to help you get your business or products booming email us at email@example.com