|
explain SELECT MAX(SUBSTRING(x0_.username FROM 11) * 1) AS sclr_0 FROM xcart_customers x0_ WHERE (x0_.username REGEXP 'tuttofare.[0-9]+') = 1;
-----
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
-----
| 1 |
SIMPLE |
x0_ |
index |
NULL |
username |
386 |
NULL |
4196194 |
Using where; Using index |
-----
explain SELECT MAX(SUBSTRING(x0_.username FROM 11) * 1) AS sclr_0 FROM xcart_customers x0_ WHERE (x0_.username REGEXP 'tuttofare.[0-9]+')=1 and x0_.username like 'tuttofare%' ;
-----
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
-----
| 1 |
SIMPLE |
x0_ |
range |
username |
username |
386 |
NULL |
3359 |
Using where; Using index |
-----
|