The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
MySQL - stumped using GROUP_CONCAT result in WHERE clause
Hello, having a little trouble here with a query and hoping someone here knows the answer without having to do a query within the select statement...
My query: PHP Code:
The field `sc_groupid` is produced above using GROUP_CONCAT(), usually this will result in a string like this: '6' however sometimes also like this: '6,8,22,102' Is this possible to do without a subquery? If I must use a subquery, how would I do so? I'm not too good yet with complex queries , thanks in advance --------------- Added [DATE]1239318050[/DATE] at [TIME]1239318050[/TIME] --------------- Another thing i tried was this way, I expected this to work, however it returns no rows, which makes even less sense... PHP Code:
SOLVED - i forgot all about FIND_IN_SET() that works PHP Code:
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|