Re: bookmarks and keywords

Hi Kevin,

Kevin Waterson wrote:
> I have a table of bookmarks that have keyword searching.
> Fields
>
> +-------------+----------------------+--------------------------+------------------+
> | bookmark_id | bookmark_title | bookmark_url | bookmark_keyword |
> +-------------+----------------------+--------------------------+------------------+
> | 1 | number one | http://www.phpro.org | php |
> | 2 | number 2 | http://www.freshmeat.net | software |
> | 3 | three here | http://www.php.net | php |
> | 4 | and four | http://www.redhat.com | linux |
> | 5 | the fifth | http://www.ez.no | php |
> | 6 | this will do | http://www.google.com | search |
> | 7 | something about fish | http://www.youtube.com | linux |
> | 8 | finally | http://www.redhat.com | php |
> +-------------+----------------------+--------------------------+------------------+
>
> I wish to select all bookmark_title and bookmark_url that have the same keywords as
> the bookmark_url 'http://www.redhat.com. I do this..
> mysql> SELECT child.bookmark_id, child.bookmark_title, child.bookmark_url FROM bookmarks AS child join bookmarks AS parent ON parent.bookmark_keyword = child.bookmark_keyword WHERE child.bookmark_url='http://www.redhat.com' GROUP BY child.bookmark_keyword;
>

That query is right.

> But this returns..
> +-------------+----------------+-----------------------+
> | bookmark_id | bookmark_title | bookmark_url |
> +-------------+----------------+-----------------------+
> | 4 | and four | http://www.redhat.com |
> | 8 | finally | http://www.redhat.com |
> +-------------+----------------+-----------------------+

But, the JOIN table from which those columns come actually has the columns you want from the parent table as well. It's just that you're selecting the child columns.

Baron

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com