Re: Still struggling witn like 'CTV%' over varchar.... I simple cannot understand..

- Original Message - From: Andrés Tello mr.crip...@gmail.com showed the usage of the index, then, some time later, it show, for the same query, the usage of no index... Look at the rows field. It's obvious that this table is live and rather on the active side; and the data has

Still struggling witn like 'CTV%' over varchar.... I simple cannot understand..

mysql explain select * from cuenta where rutaCuenta like 'CTV%'; ++-++---+---++-+--++-+ | id | select_type | table | type | possible_keys | key| key_len | ref | rows | Extra |