This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Mysql keyword search" Watch "Mysql keyword search" New topic

Mysql keyword search

Al Hollis
Ranch Hand

Joined: Dec 12, 2005
Posts: 60

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

Gerardo Tasistro
Ranch Hand

Joined: Feb 08, 2005
Posts: 362
Al, read into MySQL full text search capability in MyISAM tables.
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.
subject: Mysql keyword search
It's not a secret anymore!