Fulltext searching
Just create a table, and if the column data structure is right (text, blob, ... etc) you can create a column as a fulltext searchable column by using the following syntax,
mysql> alter table <table_name> add fulltext (<column_name>);
You can separate the columns in the syntax above with a comma if you want more than one to be indexable.
Then you use queries like,
mysql> select * from <table> where match(<column_name>) against ('search pattern' in boolean mode);
Again, you can add more columns to the match(<column_name>) syntax by separating them with commas.
http://jeremy.zawodny.com/blog/archives/000576.html »
[Click to add or edit comments])
Please prepend comments below including a date