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 switched
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
required
I have a table of bookmarks that have keyword searching.
Fields
+-+--+--+--+
| bookmark_id | bookmark_title | bookmark_url |
bookmark_keyword |
Hi Kevin,
Kevin Waterson wrote:
I have a table of bookmarks that have keyword searching.
Fields
+-+--+--+--+
| bookmark_id | bookmark_title | bookmark_url |
bookmark_keyword |
Kevin Waterson schrieb:
I have a table of bookmarks that have keyword searching.
Fields
+-+--+--+--+
| bookmark_id | bookmark_title | bookmark_url |
bookmark_keyword |
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 |
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 |
bookmark_keyword
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.bookmark_url =
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
FROM
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,
10 matches
Mail list logo