Re: [SQL] select question - Mailing list pgsql-sql

On Tue, 28 Jul 1998, STMIK Stikubank wrote:

> 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';

select * from mhs where nim like '94.31.%';