mao ni ako gisulayan mysql> SELECT GROUP_CONCAT(client_name SEPARATOR '|') as myfield FROM clients;
in-ani dayon iya result +-------------------------------+ | myfield | +-------------------------------+ | bill gates | linus torvalds | +-------------------------------+ naa jud diay.. i concat niya ang results as usa ka row tapos iyang separator kay any string power.. naa diay ana nga klase na concatenation... karon pa ko kabalo.. thanks arthur! pero iya return ani kay STRING lang.. so imong reference na lang dayon pagbulag is kanang character/string na gigamit nimo as SEPARATOR.. puede pud kaha na mu-return siya ug array() without using PHP? bale murag in-ani? myfield[0] -> "bill gates"; myfield[1] -> "linus torvalds"? 2007/5/18, Arthur Gapusan <[EMAIL PROTECTED]>:
try daw ni wahoho... SELECT GROUP_CONCAT(lastName SEPARATOR ' ') FROM tablename; On 5/18/07, Richard Badlisan < [EMAIL PROTECTED]> wrote: > > bale kung simple query lang is inani lugar ang result: > > +-----------+----------------+ > | client_id | client_name | > +-----------+----------------+ > | 1 | bill gates | > | 2 | linus torvalds | > +-----------+----------------+ > > tapos gusto dayon nimo i-in-ani ang result?: > > +--------------+----------------+ > | client_name1 | client_name2 | > +--------------+----------------+ > | bill gates |linus torvalds | > +--------------+----------------+ > > para sa akoa bai.. murag gamit jud ka ug PHP ana then isulod nimo sa > loop.. > > ambot lang anang concat sa sql, aside sa fields which is possible (e.gfield1 + field2), i dunno kung sa rows. diha na siguro jud ka mugamit ug > PHP... pero i dunno.. basin naa jud.. tsada ni nga pangutana.. > > 2007/5/18, Jason Yap <[EMAIL PROTECTED]>: > > > > uu inana pero ang gusto nako kay i concat nya ang mga result sa usa ka > > query. > > > > On 5/18/07, Arthur Gapusan <[EMAIL PROTECTED] > wrote: > > > > > > Yap..pwede man ka mag concat sa sql mismo.. > > > > > > SELECT concat(field1, field2, field3) FROM tablename; > > > > > > pwede jpn nimo sagulan ug lain string.. > > > > > > SELECT concat(familyName, " ", firstName) FROM tablename; > > > > > > ingon ana ba imo pasabot? > > > > > > On 5/18/07, Jason Yap < [EMAIL PROTECTED]> wrote: > > > > > > > > sa console ko sa mysql ga buhat. ang ako lang, gusto nako na tanan > > > > retreiving of data buhaton ra sa mysql. as much as possible, ang gusto lang > > > > nako buhaton sa php is i-present ra ang data. wala nay mga data > > > > manipulation(concatenation,etc...) mahitabo sa php. sa mysql ra sya tanan. > > > > pero kung dili jud ni possible, sa php jud ko padulong ani. hehe > > > > > > > > On 5/18/07, Richard Badlisan < [EMAIL PROTECTED]> wrote: > > > > > > > > > > dako jud na nga question mark para sa akoa pre.. > > > > > naa lang pud koy pangutana.. kung wala ka sa shell, unsaon nimo > > > > > pag execute sa query mismo? diba dependent man pud ang sql sa language na > > > > > imo gamiton like php, asp? aha diay nimo na siya ipadagan? kay kung sa > > > > > browser lang.. la ko idea kung puede na w/out using php... LAMP gud kunuhay > > > > > na sila.. IMO lang nuon. > > > > > > > > > > maghulat pud ko sa mga tubag sa uban about ani kay murag > > > > > interesado ko ani nga pangutana pud.. > > > > > > > > > > *ga-atang sa kilid* > > > > > > > > > > 2007/5/18, Jason Yap < [EMAIL PROTECTED]>: > > > > > > > > > > > > Hi guys. Naa ko pangutana about sql query > > > > > > > > > > > > ang gusto nako mahitabo kay unsaon pagbutang sa isa ka row ang > > > > > > multiple results sa usa ka query without using php. > > > > > > > > > > > > example: > > > > > > > > > > > > kung sa normal query, ang results would be: a,b,c,d,e where > > > > > > each result is a row. > > > > > > > > > > > > ang gusto nako mahitabo kay query gihapon, same result, > > > > > > a,b,c,d,e, but in one row nlang. > > > > > > > > > > > > > > > > > > Is this possible in mysql without using php? > > > > > > > > > > > > Any help will be appreciated. Thanks :) > > > > > > > > > > > > -- > > > > > > "Just being alive is such a lovely and wonderful thing." > > > > > > _________________________________________________ > > > > > > Kagay-Anon Linux Users' Group (KLUG) Mailing List > > > > > > [email protected] (http://cdo.linux.org.ph) > > > > > > Searchable Archives: http://archives.free.net.ph > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > » http://www.syntacticsinc.com/ > > > > > » http://g0ma.blogspot.com/ > > > > > » [EMAIL PROTECTED] > > > > > » 呵呵呵......不告訴你! ♥ + ♦ ⇒ ♫ > > > > > _________________________________________________ > > > > > Kagay-Anon Linux Users' Group (KLUG) Mailing List > > > > > [email protected] (http://cdo.linux.org.ph) > > > > > Searchable Archives: http://archives.free.net.ph > > > > > > > > > > > > > > > > > > > > > -- > > > > "Just being alive is such a lovely and wonderful thing." > > > > > > > > _________________________________________________ > > > > Kagay-Anon Linux Users' Group (KLUG) Mailing List > > > > [email protected] (http://cdo.linux.org.ph) > > > > Searchable Archives: http://archives.free.net.ph > > > > > > > > > > > > > _________________________________________________ > > > Kagay-Anon Linux Users' Group (KLUG) Mailing List > > > [email protected] (http://cdo.linux.org.ph) > > > Searchable Archives: http://archives.free.net.ph > > > > > > > > > > > -- > > "Just being alive is such a lovely and wonderful thing." > > > > _________________________________________________ > > Kagay-Anon Linux Users' Group (KLUG) Mailing List > > [email protected] (http://cdo.linux.org.ph) > > Searchable Archives: http://archives.free.net.ph > > > > > > -- > » http://www.syntacticsinc.com/ > » http://g0ma.blogspot.com/ > » [EMAIL PROTECTED] > » 呵呵呵......不告訴你! ♥ + ♦ ⇒ ♫ > > _________________________________________________ > Kagay-Anon Linux Users' Group (KLUG) Mailing List > [email protected] (http://cdo.linux.org.ph) > Searchable Archives: http://archives.free.net.ph > _________________________________________________ Kagay-Anon Linux Users' Group (KLUG) Mailing List [email protected] (http://cdo.linux.org.ph) Searchable Archives: http://archives.free.net.ph
-- » http://www.syntacticsinc.com/ » http://g0ma.blogspot.com/ » [EMAIL PROTECTED] » 呵呵呵......不告訴你! ♥ + ♦ ⇒ ♫
_________________________________________________ Kagay-Anon Linux Users' Group (KLUG) Mailing List [email protected] (http://cdo.linux.org.ph) Searchable Archives: http://archives.free.net.ph
