Sagewire Logo

Compare every word in paragraph with every row in database

3 Message(s) by 3 Author(s) originally posted in php sql


From: blackrosezy Date:   Tuesday, September 25, 2007
My problem is I want to compare every word in large paragraph with
every row in data base.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'll 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?


From: Captain Paralytic Date:   Wednesday, September 26, 2007
wrote in message:
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'll 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?


From: Tom Date:   Wednesday, September 26, 2007
wrote in message...
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'll 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?
The approach I might take'd be splitting the words in your paragraph into a


hash array . Then run a SELECT query in your SQL and capture the results into
another array. That way you've an apples to apples comparison. From that point
you can run a "for" loop through one array and compare it to the other.

Tom
--
NewsGuy Takes Usenet Cellular!
Download newsgroup MP3's to your Cell or PDA
Free Trial - http://newsguy.com/cell phone.htm



Next Message: Whats the most portable way to identify field existence?


Blogs related to Compare every word in paragraph with every row in database

Welcome to my awesome website! Word up, you all.
woodlands harley every blooming thing petition takes aim at funds surcharge (boston globe) cerkva pottery site handmade pen handmade pen wooden pen foutain pen mywoodworkingstore.com lay me down and bleed a while and the fight fight ...

Welcome to my awesome website! Word up, you all.
download fullmetal alchemist lyrics i feel it every day msm327 name meanings ardith. beil canada free reverse phone lookup. hotel rates book discount find save online call guaranteed Aire acondicionado de un automovil ultra trailer coax ...

Welcome to my awesome website! Word up, you all.
camera phone liquidation cingular uniden voip dcx640 my boyfried flirts with every woman he meets motorola cell phone review lg cell phone review cell phone maryanne garry purchase inventory tracking software sewellteethwhitening. ...

Im supposed to add a few functions to an application Today all sql ...
flawed premise. php requests are not that dynamc. and many page components are often quite static. it's just a matter of designing the app properly. with smarty you can have parts of your page update only every 10 minutes and use a ...

Welcome to my awesome website! Word up, you all.
Make-and-take-care-of-your-own-virtual-pet company hosting irish web frys fifth grade word wall words medicina alternativa en internet box furniture jewelry musical southeast hospital cape girardeau mo villard wheel for eve online medal ...

Welcome to my awesome website! Word up, you all.
body piercing, olympia, wa Camping site story kids summer camp illustration ingis & company kpn voip word embedded excel color windstar cruises costa rica foreign exchange program for high school student 20 briana labatidora online ...


Programming | Sports | Autos

copyright 2006
Valid XHTML 1.0 Transitional