GROUP_CONCAT bug? - MySQL Database

peter stickney

I am using the GROUP_CONCAT() as follows:

SELECT (SELECT CONCAT(ProjectName) FROM Project WHERE
FIND_IN_SET(ProjectID, RelatedProjectID))AS RelatedProject

We have a project tracker system and we can have one project be
related to several different projects. the issue is when there is
only 1 related project associated with another project, this query
does not work. Is there some sort of bug with GROUP_CONCAT?

Jul 20 '05 #1

Subscribe Post Reply

2591

Peter

I do not see the group_concat function used in your example.
I did not see either "GROUP BY" Remember GROUP_CONCAT must be accompanied
by GROUP BY

Hernando
"peter stickney" <pe***@peterstickney.com> wrote in message
news:fc**************************@posting.google.c om...

I am using the GROUP_CONCAT() as follows:

SELECT (SELECT CONCAT(ProjectName) FROM Project WHERE
FIND_IN_SET(ProjectID, RelatedProjectID))AS RelatedProject

We have a project tracker system and we can have one project be
related to several different projects. the issue is when there is
only 1 related project associated with another project, this query
does not work. Is there some sort of bug with GROUP_CONCAT?

Jul 20 '05 #2

Similar topics

GROUP_CONCAT bug?

by: peter stickney | last post by:

I am using the GROUP_CONCAT() as follows: SELECT (SELECT CONCAT(ProjectName) FROM Project WHERE FIND_IN_SET(ProjectID, RelatedProjectID))AS...

MySQL Database

Why does GROUP_CONCAT() function fail in MySQL 4.1.12 in this query?

by: phillip.s.powell | last post by:

Here are my results using MySQL 4.1.12 and I honestly don't think this is right, but can't figure out what to do: mysql> select id,...

MySQL Database

GROUP_CONCAT() produces fatal error in MySQL 4.1.12 - time-sensitive issue

by: phillip.s.powell | last post by:

SELECT s.id, s.student_first_name, s.student_last_name, IF(s.student_ethnicity_interest_other IS NOT NULL AND s.student_ethnicity_interest_other !=...

MySQL Database

Filtering resultsets based on GROUP_CONCAT() generated value

by: phillip.s.powell | last post by:

$if1 = "IF(s.student_ethnicity_interest_other IS NOT NULL AND s.student_ethnicity_interest_other != '', " . " ...

MySQL Database

Group_concat Question

by: gmorris | last post by:

I am attempting to pull data from multiple tables into a resultset that I can use as an Excel spreadsheet for reporting. Here is my query so far:...

MySQL Database

Array manipulation

by: lukemack | last post by:

Hi, I have an array in the following format : Array ( =Array ( =Array (

PHP

Multiple JOINS and controlling duplicates

by: beargrease | last post by:

I'm kind of comfortable with basic joins, but a current project requires a complex query of many tables. The GROUP_CONCAT(DISTINCT ...) function has...

MySQL Database

GROUP_CONCAT not working for > 283

by: rizwan6feb | last post by:

I have created a table (with only 2 fields) with the following query "CREATE TABLE `users` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,...

MySQL Database

Group_concat()

by: bilibytes | last post by:

Hi, I'm wondering how to achieve the following: well i don't know if you guys like wine but I have to explain a very little on wine to explain...

MySQL Database

Benefits of Blockchain App Development for Enterprise Businesses

by: Kemmylinns12 | last post by:

Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...

General

https redirect with reverse proxy

by: jalbright99669 | last post by:

Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...

IIS / Internet Information Server

Hyperconverged All-in-One Streaming Engine, ushering in new age for distributed database

by: antdb | last post by:

Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...

General

How to layout php header location with a variable as the location?

by: Matthew3360 | last post by:

Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...

PHP

How to use http requests (Get function) to get variable value?

by: Matthew3360 | last post by:

Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...

Python

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computer

by: AndyPSV | last post by:

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

General

How do I view Redshift db tables in Alteryx

by: Arjunsri | last post by:

I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...

General

PHP Curl Not wanting to connect to localhost.

by: Matthew3360 | last post by:

Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...

PHP

Join our open community on Discord to learn programming, SEO, and marketing

by: BLUEPANDA | last post by:

At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...

General