fulltext search

[himmatpatil]

hi all

i devloped one application for the search using fulltext server
for the fulltext query i used freetext.

if suppose i search for "Auto"

it will give me the following results

1. Auto
2. Autos
3. Automobile
4. Autoclub
5. RealAuto

i am able the highlight the result for the keyword only means("Auto&quot in the above result
but i want the all above result highlighted because it contains the word auto.
Is there any solution for this......

plz do help

 

[Spellman]

Try using the following query

Select * from tablename where name like '*auto*' Mark

The key to immortality is to make a big impression in this life!!

 

[himmatpatil]

this is ok for the query and result i have no problem but the problem with the result highlightin i want all below word in red color if i search for Auto

1. Auto
2. Autos
3. Automobile
4. Autoclub
5. RealAuto