<?php
$minAge = 86400; // 24h
$rows = array(
'import_1364893316_foobar',
'import_1364893306_foobar',
'import_1364893216_foobar',
'import_1364892316_foobar',
'import_1364883316_foobar',
'import_1364793316_foobar',
'import_1363893316_foobar',
'import_1354893316_foobar',
'import_1354893416',
'import_1354893316',
);
$drops = array();
$maxCreatedAt = true === $minAge
? time() - $minAge
: time() + 1;
foreach ($rows as &$row) {
if (preg_match('/_([0-9]+)[0-9]{6}[_a-zA-Z]*$/', $row['table_name'], $matches)) {
var_dump($matches[1]);
if ($maxCreatedAt > (int) $matches[1]) {
$drops[] = $row['table_name'];
}
}
}
var_dump($drops);
preferences:
30.15 ms | 402 KiB | 5 Q