Simple like filter - Mailing list pgsql-novice

From Ruzsinszky Attila
Subject Simple like filter
Date
Msg-id f637dd860908270339m2310c57dgf1c73135b9d3f801@mail.gmail.com
Whole thread Raw
Responses Re: Simple like filter  (Greg Stark <gsstark@mit.edu>)
List pgsql-novice
Hi,

My data are look like:
1_123456
11_123456
111_123456
1111_123456
11111_123456 (varchar(20))

I would like a where like SQL command.
I tried this: like E'11\_%' -> wrong!
like E'11\_______' -> good (with 7 piece of _ characters!)

What would I have to do if the second part of the numbers (after the
_ character) will be different lenght?

TIA,
Ruzsi

pgsql-novice by date:

Previous
From: Jignesh Shah
Date:
Subject: Create generic Function definition in Perl
Next
From: Gabor Szokoli
Date:
Subject: psql variable from query result