MySQL: How to search a value in the whole table.

If you want to search a value in the whole table:

1) You have to enable full text indexing on the columns.
2) Column types have to text/char/varchar.
3) Search by the MATCH() AGAINST() functions.
4) You cannot match text having length less than 4. There is a work around to it. I'll write about that later.

Details can be found here:

http://dev.mysql.com/doc/refman/5.0/en/fulltext-natural-language.html