Results 1 to 7 of 7
Dec 9, 2008, 00:00 #1
need unique entries... distinct not working
I have a table with 3 columns. ex: column A, column B, column C.
Column B has a unique index. The problem is, even though there are no duplicates in column B, There may be 5000 exact matches in Column A. I can't use a unique on column A cause column A isn't immediately populated, and may be left blank for sometime. And column B reflects all the different pages(unique). (If I apply unique to Column A I lose half of what I got in Column B) I tried SELECT DISTINCT, but it has no effect at all. The results are the same whether I use it or not. Please help, I've been suffering with this delima for a while now. Thanks.You know you cooler than me...
Dec 9, 2008, 00:53 #2
- Join Date
- Jun 2006
- Durban, South Africa
- 0 Post(s)
- 0 Thread(s)
Can you post some sample data, and what exactly you are trying to select?
Dec 9, 2008, 03:51 #3
Title | example/a |Summary a
Title | example/b |Summay b
Title | example/c |Summary c
| example/d |
I can't apply a unique to the Title or Summary Fields cause the center(example/?) fills up 10 times faster than the Title or Summary, and the Unique Index will erase the entire record because of the null valuesYou know you cooler than me...
Dec 9, 2008, 04:09 #4
Why do you want to apply a unique index to the title or summary field?
What are you trying to achieve?Guido - Community Team Leader
The Votes Are In: The Winners of the 2013 Community Awards are...
Blog - Free Flash Slideshow Widget
Dec 9, 2008, 05:49 #5
cause I can't have different pages(Column B) represented by the same name multiple times, more precisely, this is my webcrawler for my search engine. It gets title, links, and a description of each page. However different pages have the same title, which makes it harder on the viewer requesting search results. The webpage links are inserted into my database at a rate of 100/1. Then the title and descriptions are retrieved. I simply can't have say 1500 different pages from Amazon.com represented with the same title Amazon. I thought of query-ing each title before updating the records, but this causes too much processing power and waste even more time.You know you cooler than me...
Dec 9, 2008, 06:12 #6
- Join Date
- Jul 2002
- Toronto, Canada
- 63 Post(s)
- 3 Thread(s)
Dec 9, 2008, 06:27 #7
THE URL is UNIQUE, my problem comes to the search, I don't want 5000 same titles matching 5000 different urls. It wouldn't be as bad if the description varied greatly on each page, but a lot of these url's have the same description too. So even though all the url's are unique, the user has no way of knowing exactly what they're searching for.. because everything looks the same. Example: GOOGLE will omit search results that tend to repeat in descriptive context and title. This is what I'm looking for. I tried "SELECT DISTINCT title,link,summary .... but there's nothing distinct about it.You know you cooler than me...