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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]