Best ways to preform a search

Started by Tim, May 30, 2005, 05:26:15 PM

Previous topic - Next topic

Tim

I'm looking for the best ways to search a table using PHP and MySQL. I'm looking for something that would be rather light on the server but would still be powerful enough to return rather accurate results.

Does anyone know a good tutorial on this? Or has some advice?

[Unknown]

If you think it's going to be read/searched more than written to, I strongly recommend using a fulltext index.  However, you're still going to end up using LIKE, etc. for short search terms.

Search dev.mysql.com for "FULLTEXT".

-[Unknown]

Advertisement: