DekGenius.com
Home
(current)
Dictionary
BOOKS
LYRICS
CHORD
SCRIPT & CODE EXAMPLE
Karaoke language
Search
Go
SCRIPT & CODE EXAMPLE
CODE EXAMPLE FOR SQL
mysql select multiple rows into one column
SELECT
GROUP_CONCAT
(
DISTINCT
id SEPARATOR
', '
)
AS
'ids'
FROM
table_name
WHERE
column_name
=
'value'
PREVIOUS
NEXT
Tagged:
#mysql
#select
#multiple
#rows
#column
ADD COMMENT
Topic
COMMENT
Name
9+2 =
Submit