Questions about the maximum number of queries encountered

The problem with the maximum number of queries encountered
Data table Field 2

Name Num


Name word Gencun such as AA BB cc and so on names

num character Gencun a:4:{i:2009;s:1: "0"; I:2010;s:1: "0"; I:2011;s:1: "0"; i:2012;s:1: "1";}

This sequence field
After deserialization is
Array
' =>0 ',
' =>0 ',
' =>0 ',
' =>1 '
)
And the value is 1

Then the operation is to query out the top 10 records of NUM and the maximum value,

How to do it?

------Solution--------------------
If it is a MySQL database, it can only be removed after all, sorted by program
But if you have already asked for it in storage, you can use the MySQL function to precipitate

If it is a SQLite database, you can register a PHP function with it to do
------Solution--------------------
Saving JSON is a tragedy. Let's do it in PHP.
------Solution--------------------
Test the terminal judgment.
------Solution--------------------
All taken out for judgment

