Andrew... I think most likely you will have to pull the information into a php page and parse it.
you then will be able to get accurate results and I dont know if mysql has an explode function it doesnt look like it http://www.mysql.com/doc/en/Function_Index.html ----- Original Message ----- From: "Andrew McCombe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 9:16 AM Subject: Re: [PHP] mysql split? > Does mysql have an explode function? I suppose this is the wrong place to > ask... > > Andrew > > ----- Original Message ----- > From: "Jay Blanchard" <[EMAIL PROTECTED]> > To: "Andrew McCombe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, June 27, 2003 5:08 PM > Subject: RE: [PHP] mysql split? > > > > use explode() > > > > -----Original Message----- > > From: Andrew McCombe [mailto:[EMAIL PROTECTED] > > Sent: Friday, June 27, 2003 11:06 AM > > To: [EMAIL PROTECTED] > > Subject: [PHP] mysql split? > > > > > > Hi > > > > I have a field in mysql that has paths to files such as: > > > > project/entertainment/andrew/job/1.jpg > > project/corporate/roberts/job/1.jpg > > project/corporate/andrew/job/1.jpg > > project/identity/john/job/1.jpg > > > > The first level is always 'projects'. What I want to do is get the > > unique > > name for the 3rd level for all entertainment, corporate and identity, so > > from the data above I would get returned: > > > > andrew > > john > > roberts > > > > What's the best way to acheive this? I remember seeing something where > > you > > can split a field in the mysql into parts (ie, split at /)? or would a > > regex be better ('WHERE REGEX > > "^projects/corporate|entertainment|identity/' > > (this doesnt work))? Hope someone can help. > > > > > > > > > > Regards > > Andrew McCombe > > Interactive Web Solutions (Stafford) > > Tel: 01785 279921 > > > > > > > > ------------------------------------------------------------------------ > > ---- > > ------------------------- > > The contents of this e-mail and any attachments are confidential and may > > be legally privileged. If you have received this e-mail and you are not > > a named addressee, please inform us as soon as possible on > > +44 (0) 1785 279920 and then delete the e-mail from your system. If you > > are > > not a named addressee you must not copy, use, disclose, distribute, > > print or rely on this e-mail. Any views expressed in this e-mail or any > > attachments may not necessarily reflect those of Interactive Web > > Solutions' > > management. > > Although we routinely screen for viruses, addressees should scan this > > e-mail and any attachments for viruses. Interactive Web Solutions makes > > no > > representation or > > warranty as to the absence of viruses in this e-mail or any attachments. > > Please note that for the protection of our business, we may monitor and > > read e-mails sent to and from our server(s). > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php