RSS
Home
|
Link Us
|
Contact
Categories
-- All --
Perl
PHP
MySQL
Windows
JavaScript
HTML
Apache
CVS
Linux
SEO
Perl (9)
PHP (35)
MySQL (5)
Windows (7)
JavaScript (5)
HTML (6)
Apache (6)
CVS (4)
Linux (13)
SEO (11)
The registration is temporarily disabled.
However you can post your comments without registration.
Authentication
Username:
Password:
Register
|
Lost password
-->
Building comma-separated list of strings with MySQL
Home
»
MySQL
»
Building comma-separated list of strings with MySQL
Date: 2007-12-13
How to Build a comma-separated list of strings with MySQL
Download
|
Printer Friendly
Add to Google
Add to Del.icio.us
Add to Digg
Add to Technorati
Add to Yahoo!
Add to Blinklist
Add to Furl
Add to reddit
SELECT cats.id as cat_id, GROUP_CONCAT(keyword ORDER BY keyword DESC SEPARATOR ',') as keywords FROM YOURPREFIX_categories cats, YOURPREFIX_keywords kws WHERE cats.id = kws.cat_id GROUP BY cats.id
Comments
No comments yet.
Post a comment
Your Name
Your Email
(won't be published)
Site
(e.g. http://)
*
Title
*
Comment
*
Required fields.
Copyright © 2005-2008
Execution time: 0.19629
hosted by
1and1