Re: Query question

From: "Ligia M(dot) Pimentel" <lmpc(at)nettaxi(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Query question
Date: 2001-01-17 17:45:05
Message-ID: 944m3o$11ih$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

use
Select * from my_table where my_field LIKE 'A%'

the % stands for *.

"Jorch" <jorch(at)saunalahti(dot)fi> wrote in message
news:3A648758(dot)71C69867(at)saunalahti(dot)fi(dot)(dot)(dot)
> How can I make query
>
> SELECT * FROM my_table WHERE my_field = 'A*';
>
> Meaning that I want to get all rows from my_table where my_field value
> begins with alphabet "A"
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adam Haberlach 2001-01-17 18:03:45 Re: Spot the error in my plpgsql...
Previous Message Ligia M. Pimentel 2001-01-17 17:42:50 Re: View tables relationship