[Lionel]

I am doing this query in calendar event where I pull the customfields which are serialized. One of these customfields indicates a round number:

a:6:{i:1;s:10:"Aigle Noir";i:2;s:8:"Dynamite";i:3;s:35:"Port-au-Prince - Stade Sylvio Cator";i:4;s:15:"Digicel Cloture";i:5;s:1:"9";i:6;s:14:"First Division";}

So is it possible to grab only the similar in the below query? Meaning only the same with that value s:1:"9";

That values indicates round number and I am trying to prevent rounds to be mixed. For example, when I display results for round 10 and it's less than the set LIMIT of 8, I don't want to display 3 round number 10 and 5 round number 9. Just the latest 3 round of 10. If not, my info for round will be wrong.

Here is the query.

PHP Code:

$getgamesbits = $db->query("SELECT events.customfields,scores.team1 as team1, scores.team2 as team2,scores.team1_score as homescore,scores.team2_score as awayscore,scores.season as season,scores.id as gameid 
FROM " . TABLE_PREFIX . "event as events 
LEFT JOIN cclp_schedule_scores as scores ON(events.eventid = scores.eventid)
WHERE calendarid='4' and scores.team1 !='' ORDER BY dateline_from DESC LIMIT 8" );