FullText Search - SQL Server
+ Reply to Thread
Page 2 of 5 FirstFirst 1 2 3 4 ... LastLast
Posts 11 to 20 of 48
  1. #11

    Godlike


    Join Date
    Sep 2014
    Location
    Non-Event Horizon
    Posts
    8,952
    Thanks (Given)
    367
    Thanks (Received)
    641
    Likes (Given)
    2318
    Likes (Received)
    2737

    Default

    Quote Originally Posted by MrMarkyMark View Post
    Why would it???

    % just looks for Unknowns at the end of your string?

    The "r" isn't at the end..
    Att with CONTAINS or FREETEXT should turn up the row where a correctly indexed column contains Att (no wildcards needed).
    The greatest trick the devil ever pulled was convincing the world that he didn't exist

  2. #12

    Double Godlike!


    Join Date
    Dec 2012
    Posts
    10,793
    Thanks (Given)
    821
    Thanks (Received)
    816
    Likes (Given)
    5230
    Likes (Received)
    3029

    Default

    Quote Originally Posted by LondonManc View Post
    Att with CONTAINS or FREETEXT should turn up the row where a correctly indexed column contains Att (no wildcards needed).
    ah.....gotcha

    I should add though I was explicitly talking about eh Like search string he posted.

  3. #13

    Potty-trained

    suityou01's Avatar
    Join Date
    Jan 2009
    Location
    Skid row
    Posts
    20,969
    Thanks (Given)
    177
    Thanks (Received)
    212
    Likes (Given)
    745
    Likes (Received)
    717

    Default

    Quote Originally Posted by MrMarkyMark View Post
    Why would it???

    % just looks for Unknowns at the end of your string?

    The "r" isn't at the end..
    In the process of coding, and then popping back here to answer queries, I made a mistake.

    I did actually mean
    Code:
    Like '%attrn'
    works
    Brillo invited me back.

  4. #14

    Double Godlike!


    Join Date
    Dec 2012
    Posts
    10,793
    Thanks (Given)
    821
    Thanks (Received)
    816
    Likes (Given)
    5230
    Likes (Received)
    3029

    Default

    Quote Originally Posted by suityou01 View Post
    In the process of coding, and then popping back here to answer queries, I made a mistake.

    I did actually mean
    Code:
    Like '%attrn'
    works
    OK, but may be worth considering LMs comment..

  5. #15

    Godlike


    Join Date
    Sep 2014
    Location
    Non-Event Horizon
    Posts
    8,952
    Thanks (Given)
    367
    Thanks (Received)
    641
    Likes (Given)
    2318
    Likes (Received)
    2737

    Default

    Quote Originally Posted by suityou01 View Post
    I did do the following

    Code:
    ALTER FULLTEXT INDEX ON MyFullTextTable SET STOPLIST = OFF
    Edit : 2012
    Run this and see if it works after that:
    Code:
    ALTER FULLTEXT INDEX ON MyFullTextTable START FULL POPULATION
    The greatest trick the devil ever pulled was convincing the world that he didn't exist

  6. #16

    Potty-trained

    suityou01's Avatar
    Join Date
    Jan 2009
    Location
    Skid row
    Posts
    20,969
    Thanks (Given)
    177
    Thanks (Received)
    212
    Likes (Given)
    745
    Likes (Received)
    717

    Default

    Quote Originally Posted by LondonManc View Post
    Run this and see if it works after that:
    Code:
    ALTER FULLTEXT INDEX ON MyFullTextTable START FULL POPULATION
    Thank you LM.

    I tried and got this.

    Warning: Request to start a full-text index population on table or indexed view MyFullTextTable' is ignored because a population is currently active for this table or indexed view.
    Brillo invited me back.

  7. #17

    Potty-trained

    suityou01's Avatar
    Join Date
    Jan 2009
    Location
    Skid row
    Posts
    20,969
    Thanks (Given)
    177
    Thanks (Received)
    212
    Likes (Given)
    745
    Likes (Received)
    717

    Default

    Quote Originally Posted by MrMarkyMark View Post
    OK, but may be worth considering LMs comment..
    I believe in either case LM is saying we are expecting a hit.

    Eg 'Attn' is contained in the string 'Attrn'
    Brillo invited me back.

  8. #18

    Godlike


    Join Date
    Sep 2014
    Location
    Non-Event Horizon
    Posts
    8,952
    Thanks (Given)
    367
    Thanks (Received)
    641
    Likes (Given)
    2318
    Likes (Received)
    2737

    Default

    Quote Originally Posted by suityou01 View Post
    Thank you LM.

    I tried and got this.
    Ah okay, so you've already got one.

    Have you used CHARINDEX to see what rows contain 'Att'?

    e.g.

    Code:
    SELECT TOP 20 * FROM MyFullTextTable 
    WHERE CHARINDEX('Att', TextColumn) >0
    The greatest trick the devil ever pulled was convincing the world that he didn't exist

  9. #19

    Potty-trained

    suityou01's Avatar
    Join Date
    Jan 2009
    Location
    Skid row
    Posts
    20,969
    Thanks (Given)
    177
    Thanks (Received)
    212
    Likes (Given)
    745
    Likes (Received)
    717

    Default

    Quote Originally Posted by LondonManc View Post
    Ah okay, so you've already got one.

    Have you used CHARINDEX to see what rows contain 'Att'?

    e.g.

    Code:
    SELECT TOP 20 * FROM MyFullTextTable 
    WHERE CHARINDEX('Att', TextColumn) >0
    Yes, and this works.
    Brillo invited me back.

  10. #20

    Godlike


    Join Date
    Sep 2014
    Location
    Non-Event Horizon
    Posts
    8,952
    Thanks (Given)
    367
    Thanks (Received)
    641
    Likes (Given)
    2318
    Likes (Received)
    2737

    Default

    In summary then, CONTAINS(YourColumn,'Att') doesn't work but CHARINDEX('Att', Yourcolumn) >0 gets results?

    You've created the full-text catalog?

    You've created the full-text index on the table and correctly associated it with the catalog above?

    Have you tried doing it by using the wizard in SSMS?
    The greatest trick the devil ever pulled was convincing the world that he didn't exist

+ Reply to Thread
Page 2 of 5 FirstFirst 1 2 3 4 ... LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Content Relevant URLs by vBSEO 3.6.0 ©2011, Crawlability, Inc.