Check out full text searching: http://www.mysql.com/doc/F/u/Fulltext_Search.html
Fast. Accurate. Cheers, -J On Mon, 20 May 2002 04:04:33 +1200, Andy wrote: > Hi there, > > I am wondering if it would be anyhow possible to make a search on a > textfield faster. Right now the table contains 294000 entries and takes > about 40 MB of space. Is there a way to apply a index with a resonable > amount of disk space? I am also not so sure if I should use text or > smalltext columns as the info may vary between 1 and 1000 chars. > > Thanx for any help on that, > > Andy -- Jason Morehouse ([EMAIL PROTECTED]) Netconcepts LTD - Auckland, New Zealand Linux: because rebooting is for adding hardware -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php