Simcha Younger-2 wrote:
> 
> If there is only one search term - "soup" your where statement would be:
>       Where `name` like 'soup'
> 
> But you need two matches, and the terms are "soup", "vegetarian". Try:
>               Where GROUP_CONCAT('name') like 'soup'
>               AND GROUP_CONCAT('name') like 'vegetarian'
>               group by taggings.id
> 

You might be onto something, couldn't get your suggestion to work out the
box but after looking at the docs

http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat

Came the following

SELECT GROUP_CONCAT(tags.name SEPARATOR ' ') as tags, `taggings`.* FROM
`tags
 LEFT JOIN `taggings` ON (tags.id = taggings.tag_id) WHERE (tags.name IN
('vegetarian', 'soup')) GROUP BY taggings.taggable_id ORDER BY tags

Gives me two records but only one of them has both tags in the concat
column.  I can then pretty much do a length check on the tags column and see
when its less than the original input 

Wasn't aware of the DROUP_CONCAT function.  Cheers for pointing it out. 

-- 
View this message in context: 
http://www.nabble.com/Delicious-style-Tags-table-tp19433010p19439195.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

Reply via email to