Scottix Posted December 11, 2006 Share Posted December 11, 2006 Ok here is my problem:I have created a news article system and I want to be able to search.I have tried using LIKE with the % operator and this works except that I get article 1 where the first occourance appears and then later on i get article 1 again where the 2nd occourance appears in the article. Is there a way I can limit the article to only appear once, because right now it displays twice. Also do you think I should use the Full Text Search other than the LIKE? Quote Link to comment Share on other sites More sharing options...
btherl Posted December 12, 2006 Share Posted December 12, 2006 Can you give more detail? LIKE will only match a row once, even if the searched for phrase appears multiple times. Quote Link to comment Share on other sites More sharing options...
fenway Posted December 15, 2006 Share Posted December 15, 2006 Correct -- there's most likely duplication in the table already. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.