Re: bookmarks and keywords

Baron Schwartz schrieb: > You have one final problem, which isn't really causing you trouble with > THIS query, but will likely bite you in the future: you are selecting > non-grouped columns in a GROUP BY query. SELECT DISTINCT will help too, of course (at least in similar cases) only if require

Re: bookmarks and keywords

Baron Schwartz schrieb: > SELECT parent.bookmark_url as pbu, parent.bookmark_keyword as pbk > FROM bookmarks AS child >JOIN bookmarks AS parent > ON parent.bookmark_keyword = child.bookmark_keyword > WHERE child.bookmark_url='http://www.redhat.com'; > > [..] no, you didn't, you just sw

Re: bookmarks and keywords

Kevin Waterson wrote: This one time, at band camp, Baron Schwartz <[EMAIL PROTECTED]> wrote: 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.boo

Re: bookmarks and keywords

This one time, at band camp, Baron Schwartz <[EMAIL PROTECTED]> wrote: > > 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

Re: bookmarks and keywords

Baron Schwartz schrieb: >> SELECT >> child.bookmark_id, >> child.bookmark_title, >> child.bookmark_url >> FROM >> bookmarks AS child >> WHERE >> child.bookmark_keyword IN ( >> SELECT >> parent.bookmark_keyword >> FROM >> bookmarks AS parent >> WHERE >> parent.bookma

Re: bookmarks and keywords

Baron Schwartz schrieb: > Hi Kevin, > > Kevin Waterson wrote: >> I have a table of bookmarks that have keyword searching. >> Fields >> >> +-+--+--+--+ >> >> | bookmark_id | bookmark_title | bookmark_url | >>

Re: bookmarks and keywords

Hi Sebastian, Kevin, Sebastian Mendel wrote: Kevin Waterson schrieb: I have a table of bookmarks that have keyword searching. Fields +-+--+--+--+ | bookmark_id | bookmark_title | bookmark_url | bookmark_

Re: bookmarks and keywords

Kevin Waterson schrieb: > I have a table of bookmarks that have keyword searching. > Fields > > +-+--+--+--+ > | bookmark_id | bookmark_title | bookmark_url | > bookmark_keyword | > +-+--

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 | +-+-

bookmarks and keywords

I have a table of bookmarks that have keyword searching. Fields +-+--+--+--+ | bookmark_id | bookmark_title | bookmark_url | bookmark_keyword | +-+--+-