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:[EMAIL PROTECTED] http://www.maurand.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
