FULL TEXT按标签或文本字段和MySQL搜索方法

Question

I have this MySQL table

id | description | tags         |
1    hi man       tag1;tag2;tag3
2    hi woman     tag0;tag2;tag9

I would like to know which is the best practice to build up a simple search engine? Is possible to have search keywords priority with only MySQL queries or need i somenthing more complex like elasticsearch, lucene, sphinx, etc .. ??

Answer 1

Just separate tags with a space, not with a semi-colon. Then add FULLTEXT indices to your table.

Geeky resource: http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

More friendly resource: http://www.artfulcode.net/articles/full-text-searching-mysql/