"mike thomas" <[EMAIL PROTECTED]> writes:
> I'll have to think about this one. My application
> just consists
> of a huge table of domain names and users will be
> able to search for
> full strings and partial strings. So I'm not sure
> how I could create
> an intermediate results set from this table that
> would speed up queries?
Split on "."?
If they're looking for mycompany's domains then splitting out the
mycompany part would be good...
--
Dave Hodgkinson, http://www.hodgkinson.org
Editor-in-chief, The Highway Star http://www.deep-purple.com
Apache, mod_perl, MySQL, Sybase hired gun for, well, hire
-----------------------------------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
