The next step up from LIKE statements is fulltext search. http://devzone.zend.com/article/1304
If you want more advanced functionality and are prepared to spend a bit of time implementing have a look at the Apache Lucene library. If you're using Hibernate there's a neat way to integrate with Lucene if you have a look at the Hibernate Search project. --- On Fri, 10/12/10, Henrique Boregio <hbore...@gmail.com> wrote: > From: Henrique Boregio <hbore...@gmail.com> > Subject: Web search functionality > To: users@wicket.apache.org > Received: Friday, 10 December, 2010, 11:02 AM > I want to add search functionality to > my site (think of a classifieds > site, something like craigslist where users post items to > sell). > > Currently I am using mysql for storage, and nothing else. > Is searching > directly at the database via queries the best way? It seems > illogical > to perform a linear search at a large mysql table using a > 'like' > statement. I'm sure there's a better way, anyone > implemented a > successful (fast, memory-friendly) search feature in a web > 2.0 site? > Thanks. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > For additional commands, e-mail: users-h...@wicket.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org