Re: How do increase memory allocated to MySQL?

[Kevin Spencer]

2011/2/3 Yannis Haralambous <yannis.haralambous@stripped>:
>
> 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.