A tekkie note about text search in MySQL
As soon as your database grows beyond a few hundred thousand datasets, searching and selecting data can be very slow. MySQL has an integrated fulltext search, that you should use, if you need to search for text snippets in your database.
Instead of using a select statement like that:
select * from TABLENAME where FIELDNAME like '%keyword%'
you should transform the column into fulltext:
alter table TABLENAME add FULLTEXT(FIELDNAME)
which gives you the possiblity to use the MATCH function of MySQL.
See the MySQL tutorial for the full description of the function.


