From: ___bug (___buggmx.net)
Date: Sun Feb 08 2004 - 03:16:59 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]