aspose file tools*
The moose likes JDBC and the fly likes Mysql keyword search Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Mysql keyword search" Watch "Mysql keyword search" New topic
Author

Mysql keyword search

Al Hollis
Ranch Hand

Joined: Dec 12, 2005
Posts: 60
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

Joined: Feb 08, 2005
Posts: 362
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

Joined: Dec 12, 2005
Posts: 60
Ahhh, i never knew about that

Thank you very much
George Stoianov
Ranch Hand

Joined: Jan 15, 2006
Posts: 94
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Mysql keyword search