I'm trying to isolate some tables in a mysql database that match a pattern which can be described as
some-name_10-digit timestamp
eg:
| oxseohistory_1381393508 |
| oxseohistory_1382427650 |
| oxseohistory_1382617597 |
Is there a way to use a regular expression which matches everything with 10 digits at the end? Like this one?
\d{10}$
I tried
SHOW TABLES FROM `usrdb_xxxx` WHERE `Tables_in_usrdb_xxxx` RLIKE '\d{10}$';
which did not work (empty set).
As MySQL does not support \d
, you can use
[[:digit:]]{10}$
Or
[0-9]{10}$