Simple SQL Select Query Question

MrQuestions · Mar 19th, 2008, 21:52

Hi,

I'm trying to return all of rows by applying a simple query to my database, however not all of the rows are being returned. The simple SQL query is:

SELECT `id` FROM `tags` WHERE `tagname`='baseball'

The rows that are left out are those in which the variable being searched for is not the first record listed in the table for a corresponding record. For example, the query of the "tags" table (below) for 'baseball' above returns only ids 10 and 12. id 11 also has a tag "baseball" but it is not being returned. What do I need to add to my query in order to return all of the ids that correspond, and not just the "first" ones? Thanks in advance!

table: tags
id | tagname
10 | baseball
10 | free
10 | stars
11 | fakeguy
11 | baseball
11 | free
12 | baseball
12 | test
12 | fantasy
12 | sports
13 | basketball
13 | hoops
13 | ncaa

Monie · Mar 19th, 2008, 23:10

I don't see what's the problem here??

Code: Select all

"SELECT id FROM tags WHERE tagname = 'baseball'"

Did you try:

Code: Select all

"SELECT * FROM tags WHERE tagname = 'baseball'"

What is your purpose of just querying the ID?

MrQuestions · Mar 20th, 2008, 01:35

The problem is that when I run the query, it only returns IDs 10 and 12. ID 11 also has a tag called "baseball," so I'm wondering why ID 11 isn't included when the query is run... seems to me that it should be, although admittedly it's been awhile since I built a web app so I'm surely rusty.

I tried SELECT * it returns only ID 10 and 12 (except it returns the 'tagname' too of course).

The purpose is that I'm trying to create an algorithm that ranks and displays "related articles" based on the tags attached to the current article. Thanks for the reply!

Monie · Mar 20th, 2008, 01:43

Are you sure ID 11 has "baseball" as the current value?

pagerss · Mar 20th, 2008, 14:32

You have only two columns, try to add one more with unique value like a key.
If this is redundant and you want all rows just
SELECT * FROM tags;

Monie · Mar 20th, 2008, 22:32

But he only want to select a field (tagname) with the value "baseball"?

pagerss · Mar 20th, 2008, 22:59

Then like you say

"SELECT * FROM tags WHERE tagname = 'baseball'"
or Questions you can try with something like
"SELECT * FROM tags WHERE tagname LIKE 'baseball'"
also can do with regular extensions but i think is not necessary.
It is quite simple query why give wrong answers. I advise you to list your rows again and carefully view it.
Good luck

Monie · Mar 20th, 2008, 23:11

That's what he is doing now but the SQL is only returning 2 row of data instead of 3!
I think there must be something wrong with the tagname value...