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
...