Compare every word in paragraph with every row in database
am 25.09.2007 22:05:08 von blackrosezy
My problem is I want to compare every word in large paragraph with
every row in database.But this technique use to much process and slow
down query performance.e.g.
My paragraph:
"This is my very very large paragraph"
My table in MySQL contains this keyword :
book
------------
this
------------
hello
------------
car
------------
very
------------
So first I will compare the word 'This' with data in every row
(book,this,hello,car,very) then following by word 'is','my',..
Is there any better to workaround this problem?
Re: Compare every word in paragraph with every row in database
am 26.09.2007 10:52:31 von Captain Paralytic
On 25 Sep, 21:05, blackros...@gmail.com wrote:
> My problem is I want to compare every word in large paragraph with
> every row in database.But this technique use to much process and slow
> down query performance.e.g.
>
> My paragraph:
> "This is my very very large paragraph"
>
> My table in MySQL contains this keyword :
>
> book
> ------------
> this
> ------------
> hello
> ------------
> car
> ------------
> very
> ------------
>
> So first I will compare the word 'This' with data in every row
> (book,this,hello,car,very) then following by word 'is','my',..
>
> Is there any better to workaround this problem?
"compare"??
What precisely are you wanting from this compare?