Post reply

Help required in Fulltext search

  • February 18, 2010 at 7:29 am

    #216841

    hello to all

    i am using full text search , my table contain firstname column which has 3 values "ijaz,ejaz and ajaz"

    my problem is if i search ijaz it only search ijaz, but my desired result will be all three names"ijaz,ajaz,ejaz".

    is it possible to search it

  • February 18, 2010 at 7:37 am

    #1120920

    if that is a specific product, i think you'd have to add the synonyms to the theosaurus file right?

    it's the same concept if i search fro "camero", but i want search matches for "Chevy","Z28" and other synonyms.

    otherwise i think you want to use the CONTAINS('jaz') statement, right?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 22, 2010 at 12:53 am

    #1122738

    THANKS FOR YOUR HELP BUT IT STILL NOT WORKING FOR ME.

    I have edit my tsENG file,which look like this

    <XML ID="Microsoft Search Thesaurus">

    <thesaurus xmlns="x-schema:tsSchema.xml">

    <diacritics_sensitive>0</diacritics_sensitive>

    <expansion>

    <sub>Internet Explorer</sub>

    <sub>IE</sub>

    <sub>IE5</sub>

    </expansion>

    <replacement>

    <pat>NT5</pat>

    <pat>W2K</pat>

    <sub>Windows 2000</sub>

    </replacement>

    <expansion>

    <sub>run</sub>

    <sub>jog</sub>

    </expansion>

    <expansion>

    <sub>Muhammad</sub>

    <sub>Mohammad</sub>

    </expansion>

    <expansion>

    <sub>Ajaz</sub>

    <sub>Ejaz</sub>

    <sub>Ijaz</sub>

    </expansion>

    </thesaurus>

    </XML>

    but it still not giving me the synonyms for ajaz

  • February 22, 2010 at 2:41 am

    #1122790

    lowell thank u so much

    i am editing the sng file, but when i edit the enu file it worked.

    thank u so much

  • February 22, 2010 at 6:04 am

    #1122875

    hey I'm glad you got it working the way you wanted! Congrats!

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 23, 2010 at 4:40 am

    #1123532

    lowell tell me one thing,i have three table in my full text catalog, each table contain a name field but they have different names, like for customer c_name, for artist a_name and for another table with w_name

    is there a way that i can perform full text search by name on these three tables

    for example, a person with name john which exists in each table will display like this

    name type

    john customer

    john artist

    john witness

    what will be the query for it??

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply