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? Link to comment https://forums.phpfreaks.com/topic/30212-using-like/ 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. Link to comment https://forums.phpfreaks.com/topic/30212-using-like/#findComment-139440 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. Link to comment https://forums.phpfreaks.com/topic/30212-using-like/#findComment-142093 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.