Maybe something like: Select LIKE pkg_name%, LIKE site_%, version from table group by LIKE pkg_name% , LIKE site_%;
but I'm still a beginner. Respectfully, Ligaya Turmelle <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello all, > > I've a table like this : > > site_1 pkg_name_1 version > site_1 pkg_name_2 version > site_1 pkg_name_3 version > ... > site_1 pkg_name_n version > site_2 pkg_name_1 version > site_2 pkg_name_2 version > ... > site_2 pkg_name_n version > ... > site_n pkg_name_1 version > ... > site_n pkg_name_n version > > > And i would like to make a sql statement to obtain a result like this ; > > |pkg | site_1 | site_2 | site_3 ... site_n > |------------------------------------------------------ > |pkg_name_1 | version | version | version ... version > |pkg_name_2 | version | version | version ... version > |pkg_name_3 | version | version | version ... version > |... > |pkg_name_n | version | version | version ... version > > > I really don't know how to write this sql request, even if there is one way > to do it... > I still hope someone will have an idea. > > Thank's for you help > > -- > Vincent > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]