Serching amd matching>
Posted: Mon Jul 02, 2007 9:09 am
hI,
I got a two database table containing three fileds each. What I want to do is to search in to one table then on the basis of that serach result I want to extract some data from the other table. So if i have ckone 150ML in my one Table I want to search the price of this product from the Table 2 by just reading product description. The product decription might be in to different form like :
ckone ED 150ML Spray
Ck one Spray 150 ML ED
ck1 150ML Tester ....
etc etc
As the product description is free form text so the product supplier can add the product description the way they want. I cant change the way they descibe the product. But mostly the product description information like (may not contain all this information and they dont follow any specific sequence)
Manufacturer type size useage Male_ female
ckone ED 150ML Spray M
so [s]plz[/s] please help me how I can search it .
[s]Thankx[/s] thanks
I got a two database table containing three fileds each. What I want to do is to search in to one table then on the basis of that serach result I want to extract some data from the other table. So if i have ckone 150ML in my one Table I want to search the price of this product from the Table 2 by just reading product description. The product decription might be in to different form like :
ckone ED 150ML Spray
Ck one Spray 150 ML ED
ck1 150ML Tester ....
etc etc
As the product description is free form text so the product supplier can add the product description the way they want. I cant change the way they descibe the product. But mostly the product description information like (may not contain all this information and they dont follow any specific sequence)
Manufacturer type size useage Male_ female
ckone ED 150ML Spray M
so [s]plz[/s] please help me how I can search it .
[s]Thankx[/s] thanks
[url=http://forums.devnetwork.net/viewtopic.php?t=30037]Forum Rules[/url] Section 1.1 wrote:11. Please use proper, complete spelling when posting in the forums. AOL Speak, leet speak and other abbreviated wording can confuse those that are trying to help you (or those that you are trying to help). Please keep in mind that there are many people from many countries that use our forums to read, post and learn. They do not always speak English as well as some of us, nor do they know these aberrant abbreviations. Therefore, use as few abbreviations as possible, especially when using such simple words.
Some examples of what not to do are ne1, any1 (anyone); u (you); ur (your or you're); 2 (to too); prolly (probably); afaik (as far as I know); etc.