2011/2/4 Yannis Haralambous <yannis.haralamb...@telecom-bretagne.eu> > SELECT * FROM wasfoundin WHERE yakoright LIKE '%geography%' >
That won't use a regular index. Have a look at fulltext indexing. For the phpmyadmin, I personally feel it's an abomination, not to mention a disaster waiting to happen; but if you really want to keep using it, you'll probably have to set the PHP script runtime timeout to something appropriately high to accomodate the long query runtimes. This can be done from within the script if neccesary, look at the PHP documentation for that. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
