2011/2/3 Yannis Haralambous <yannis.haralamb...@telecom-bretagne.eu>: > > what am I doing wrong? > > the query was just > > SELECT * FROM wasfoundin WHERE yakoright LIKE '%geography%'
When you use a leading wildcard symbol, MySQL will do a full table scan regardless of any indexes you've created. If you've got a MyISAM table, I recommend a FULLTEXT index. http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html -- Kevin. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org