On Tue, 17 Sep 2002, Chisel Wright wrote:
> On Tue, Sep 17, 2002 at 11:04:53AM +, Rafiq Ismail (ADMIN) wrote:
> > SELECT substr(content,11, 15) AS fish FROM FOO where fish='fish'
> That didn't work when I tried it:
>
> chisel=# select substring(content from 11 for 4) as fish from FOO where fis
On Tue, Sep 17, 2002 at 11:04:53AM +, Rafiq Ismail (ADMIN) wrote:
> Kind of typical, it came back to me after posting.
> > select substring(content from 11 for 4) from FOO;
> >
> >
> > and you'd like a where clause on the 4 characters?
> thus :
> SELECT substr(content,11, 15) AS fish FROM FOO
Kind of typical, it came back to me after posting.
> select substring(content from 11 for 4) from FOO;
>
>
> and you'd like a where clause on the 4 characters?
thus :
SELECT substr(content,11, 15) AS fish FROM FOO where fish='fish'
Cheers.
rafiq
On Tue, Sep 17, 2002 at 09:34:08AM +, Rafiq Ismail (ADMIN) wrote:
> I'm using postgres and remember having done something ages ago with some
> operator in mysql, although it makes zero sense to me now as to how I did
> it the first time. What I want to do is have a select return a partial
> s
Doh! SUBSTR - I forgot to wear my brain this morning.
On Tue, 17 Sep 2002, Rafiq Ismail (ADMIN) wrote:
> Hi,
>
> I'm using postgres and remember having done something ages ago with some
> operator in mysql, although it makes zero sense to me now as to how I did
> it the first time. What I wa
Hi,
I'm using postgres and remember having done something ages ago with some
operator in mysql, although it makes zero sense to me now as to how I did
it the first time. What I want to do is have a select return a partial
string from the ith character of a string to the jth character of a
string