| Author: Madeshwaran 04 Jul 2009 | Member Level: Bronze | Rating:  Points: 6 |
can you use LIKE functionality of the SQL? as select * from tbl where keyword like '%keyword%'
|
| Author: Abbas 04 Jul 2009 | Member Level: Gold | Rating: Points: 2 |
Thanks Madeshwaran
You have solved my problem thanks a lot for your help.
|
| Author: Devendra 05 Jul 2009 | Member Level: Gold | Rating: Points: 6 |
You can use like keyword
Select * from tbl where keyword like '%keyword%'
But Like Keyword is Depend on Situation
Suppose you have a key word 'Asp.Net'
And Person tries to 'sp' then it will also detect Asp.Net That is wrong
If you want to exact Match of keyword then this will give you wrong output
For Exact Match you have to use index of instead of Like
Thanks
dkmisra
|
| Author: Madeshwaran 05 Jul 2009 | Member Level: Bronze | Rating: Points: 2 |
Devendra you are correct... i think i overlooked the problem...
thanks for the correction
|
| Author: Abbas 06 Jul 2009 | Member Level: Gold | Rating: Points: 2 |
Hi Devendra,
Can you tell me what index of does and what is the syntax for index of query, how to use it.
Thanks & Regards
Abbas Electricwala
|