List:General Discussion« Previous MessageNext Message »
From:Curtis Maurand Date:February 9 2004 3:51pm
Subject:Re: mySQL search engine
View as plain text  
Have you tried "explain?"  Have you indexed the table?

Curtis

On Sun, 8 Feb 2004, ___bug wrote:

> Hello,
> 
> 
> What is the best way to search a table with about 500.000 rows of varchar
> type.
>  -------------------
> / id / time / name /
> -------------------
> Like '%blah%' and x Like '%blub%' is too slow (takes about 20 sec)
> I tried using a fulltext index and search by using MATCH() AGAINST()
> The problem is each varchar (name) contains not space seperated words but
> they are combined with . or - or _
> For example I have the following row:
> 
> | 567456 | 20040102 | Owg-08299-abzu_via.lap-2003 |
> 
> Now i want to be able to search for (sorted by date):
> Owg abzu lap
> or 
> 082 abzu_via 2003
> or
> Owg-08299-abzu_via.lap-2003
> or
> Owg 08299 abzu via lap 2003
> or 
> 99-abzu
> 
> Anyone can help me?
> 
> Thanks Chris
> 
> 
> 

-- 
--
Curtis Maurand
mailto:curtis@stripped
http://www.maurand.com


Thread
mySQL search engine___bug8 Feb
Re: mySQL search engineCurtis Maurand9 Feb