Two Laptop Bag*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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
 
Don't get me started about those stupid light bulbs.
 
subject: Mysql keyword search
 
Similar Threads
Sorting list of Bean
intersection between two collections
Do const & goto keyword?
keyword vs. reserved words
When function invoked with dynamic data it prints results in a new window