That is what I am doing right now, but it is not that fast if this system
would grow, and also it is not "ranking" the searches.

Right now I do something like this:

$searchwords = explode(" ", $searchstring);
foreach($searchwords AS $value) {
   $Query.= "OR lajlaj LIKE '%$value%'"
}

If there are many search words, the OR will grow a bit, and OR are not that
fast as I read somewhere.

/Peter

-----Original Message-----
From: JC [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 20, 2006 10:46 PM
To: Peter Lauri
Cc: mysql@lists.mysql.com
Subject: Re: FULL TEXT and Asian languages

don't know about indexing, but try to search: LIKE '%sentences%'

JC

On Thu, 20 Jul 2006, Peter Lauri wrote:

> Best group member,
> 
> I have a problem. I was going to use FULL TEXT search for my Thai client.
It
> is working smooth with English text and wordings, the indexing and search
> works fine.
> 
> The problem with Thai text is that words are not separated with a white
> space as in English and other languages. I think this screws up the
> indexing, and complete sentences are classed as a word. Assume Thai
> characters:
> 
> Thisisasentenceinthai. ButIcannotsearchforsentenceinthatsearch.
> 
> I want to search for "sentence", but can not. How can this be done? And
will
> the indexing ever work?
> 
> Best regards,
> 
> Peter Lauri
> 
>  
> 
>  
> 
> 
> 
> 

-- 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to