Re^4: ordering array of sentences

What if my @sentences has a more complicated structure? I get @sentences from querying a Sqlite database with the following:

$sentences = $dbh->selectall_arrayref("SELECT ID, sentence FROM texts 
+WHERE sentence REGEXP '(?i:$query)'");
[download]

As one can see, the result is made of two elements (ID and sentence). How can I read/manipulate in the code provided by choroba only the second element "sentence", preserving at the end of the sorting operation the same structure ID/sentence?

Comment on Re^4: ordering array of sentences Download Code

Replies are listed 'Best First'.
Re^5: ordering array of sentences by afoken (Chancellor) on Nov 14, 2012 at 06:18 UTC
use `ORDER BY` in SQL to have the data delivered to perl in the expected order Schwartzian transform Alexander -- Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)	[reply] [d/l]