[SQL] How do I do this?

I have a table with column filepath with contents that look like the following: filepath == /var/log/foo /var/log/bar /var/cache/foo /var/cache/bar /var/foo /var/bar Is there anyway to retrieve the directory information only regarding those filepaths? So that I can get /var/log

Re: [despammed] [SQL] How do I do this?

am 23.03.2005, um 12:37:54 -0500 mailte Wei Weng folgendes: I have a table with column filepath with contents that look like the following: filepath == /var/log/foo /var/log/bar /var/cache/foo /var/cache/bar /var/foo /var/bar Is there anyway to retrieve the directory

Re: [SQL] How do I do this?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a table with column filepath with contents that look like the following: .. Is there anyway to retrieve the directory information only regarding those filepaths? SELECT rtrim(substring(filepath from '.+/'),'/') FROM mytable; - -- Greg