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?

On 25 Sep, 21:05, blackros... [at] 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?

Post removed (X-No-Archive: yes)