جدول زیر از همه بیشتر مورد استفاده است:
CREATE TABLE `routes` (
`id` bigint(20) NOT NULL auto_increment,
`pattern` varchar(12) NOT NULL default '',
`edate` date default '0000-00-00',
`brate` float NOT NULL default '0',
`endpoint` varchar(10) default '0',
`priority` varchar(4) default '0',
`sdate` date default '0000-00-00',
`shour` time default '00:00:00',
`ehour` time default '00:00:00',
`routeplan` varchar(10) NOT NULL default '',
`active` char(3) NOT NULL default 'YES',
`bsetup` float NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `pattern` (`pattern`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=161117 ;
و این کوئری:
$querystring = "select * from routes where routeplan='$routeplan' and
pattern in( left('".$callednumber."',7)
,left('".$callednumber."',6)
,left('".$callednumber."',5)
,left('".$callednumber."',4)
,left('".$callednumber."',3)
,left('".$callednumber."',2)
,left('".$callednumber."',1)
) and active='YES' ORDER BY LENGTH(pattern) DESC , brate limit 1";