MySQL Forums
Forum List  »  General

Re: Split Values by comma and Check in another Table?
Posted by: Jay Alverson
Date: January 30, 2009 08:34AM

Quote

rasikow Gnaniyar Wrote:
-------------------------------------------------------

> column 2 contains sometime 10 values or 20 values
> or 2 values separated by comma.

I'm not sure what the upper limit on GROUP_CONCAT is but I've seen it handle
30+.

I just tried it with 110 and it got them all :)

>

Had to wrap the para otherwise it'll go off side of the page -->

mysql> select group_concat(forumname) from mysqlforums;

| group_concat(forumname) |

| Announcements,Newbie,Install,Source, Builds, Binaries,Docs,QA,Sample
Database (Sakila),MySQL Migration Toolkit,Microsoft SQL
Server,Oracle,Sybase,IBM DB2,Informix,PostgreSQL,Firebird,SQLite,Microsoft
Access,DBF, dBASE, FoxPro, Clipper, xBASE,Other Migration,Knowledge
Base,MySQL Monitor,MySQL Query Analyzer,MySQL Load Balancer,MySQL
Proxy,Workbench - Newbie,Workbench - Database Modeling,Workbench - Schema
Compare, Diff, Synch,Workbench - DBDoc,Workbench - SQL Browser, Editor,
Refactor,Workbench - Source, Builds, Binaries,Workbench - Plugins &
Scripts,MySQL Query Browser,MySQL Administrator,Database
Administration,Database Design and Data Modelling,Reporting, Charting, and
BI,ODBC,.NET,JDBC and Java,MySQL Connector/C++,MySQL Connector/C
(libmysql),C/C++,C#, Mono,
.Net,Java,Delphi,Python,Perl,PHP,Ruby,XML,Falcon,Maria,MyISAM,InnoDB,Federated
Storage Engine,Archive Storage Engine,CSV Storage Engine,Memory Storage
Engine,Merge Storage Engine,Custom Storage Engines,memcached,Virtualization
Systems,MySQL on Amazon E |

1 row in set, 1 warning (0.00 sec)

mysql> notee

Thanks, Jay

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.