This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Mysql keyword search

 
Al Hollis
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Im looking at a form which searches for multiple keywords and brings back valid results like google but on a much smaller basis. The keywords would be in one field in one table in one database.

I could do this easy with one word, how do i do this with multiple words?

Thanks in advance

Alan.
 
Gerardo Tasistro
Ranch Hand
Posts: 362
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Al, read into MySQL full text search capability in MyISAM tables.

http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
 
Al Hollis
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ahhh, i never knew about that

Thank you very much
 
George Stoianov
Ranch Hand
Posts: 94
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Full Text is nice but it only works on MyISAM tables which do not support referential integrity, if you need ri then you can use the SQL Like statement in combination with % and ? to make your searches those are slower than Full Text and lacking some good full text features but still an alternative.

Good luck.
George
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic