select question - Mailing list pgsql-sql

From STMIK Stikubank
Subject select question
Date
Msg-id 000901bdba3f$753426e0$0500a8c0@goofy.disney.land
Whole thread Raw
Responses Re: [SQL] select question  (Chris Johnson <cmj@inline-design.com>)
List pgsql-sql
Hi all,

I have a table (mhs)  which fills as below :

nim
--------
94.31.0001
94.31.0002
95.31.0003
95.51.0004

then how can I get rows which meet with '94.31.xxxx'  (where x = don't
care)? I've already try :

 select * from mhs where nim likes '94.31';


with no success.

TIA

edhi



pgsql-sql by date:

Previous
From: Ferruccio Zamuner
Date:
Subject: Nested classes
Next
From: Chris Johnson
Date:
Subject: Re: [SQL] select question