Optimize MySQL
Posted by admin on 3 July, 2009
1 comment so far
This item was filled under [ MySQL ]
When MySQL uses indexes
Using >, >=, =, <, <=, IF NULL and BETWEEN on a key.
SELECT * FROM `table_name` WHERE `key_part1` = 1 AND `key_part2` > 5;
SELECT * FROM `table_name` WHERE `key_part1` IS NULL;
When you use a LIKE that doesn’t start with a wildcard.
SELECT * FROM `table_name` WHERE `key_part1` LIKE ‘jani%’
Retrieving rows from [...]
