order keywords by frequency in PHP mySql
- by Gusepo
Hello,
I've got a database with video ids and N keywords for each video.
I made a table with 1 video ID and 1 keyword ID in each row.
What's the easiest way to order keywords by frequency?
I mean to extract the number of times a keyword is used and order them.
Is it possible to do that with sql or do I need to use php arrays?
Thanks