Simcha Younger-2 wrote:
>
>
> I did a little testing, and this should work better:
>
> Select...
> From...
> group by taggings.id
> HAVING GROUP_CONCAT('name') like 'soup'
> AND GROUP_CONCAT('name') like 'vegetarian'
>
>
Yep, that works also, just to clarify it needed %'s either side to work
properly, e.g.
SELECT GROUP_CONCAT( tags.name ) AS tags, `taggings` . *
FROM `tags`
LEFT JOIN `taggings` ON ( tags.id = taggings.tag_id )
GROUP BY taggings.taggable_id
HAVING GROUP_CONCAT( tags.name ) LIKE '%soup%'
AND GROUP_CONCAT( tags.name ) LIKE '%vegetarian%'
I'll do some testing when I get time on lots of tags and see which of the
methods (I now have 3) is fastest.
Thanks
--
View this message in context: http://www.nabble.com/Delicious-style-Tags-table-tp19433010p19799558.html
Sent from the Php - Database mailing list archive at Nabble.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
