Re: Query question - Mailing list pgsql-general

From Ligia M. Pimentel
Subject Re: Query question
Date
Msg-id 944m3o$11ih$1@news.tht.net
Whole thread Raw
In response to Query question  (Jorch <jorch@saunalahti.fi>)
List pgsql-general
use
   Select * from my_table where my_field LIKE 'A%'

the % stands for *.

"Jorch" <jorch@saunalahti.fi> wrote in message
news:3A648758.71C69867@saunalahti.fi...
> 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"
>
>



pgsql-general by date:

Previous
From: Adam Weeks
Date:
Subject: Re: MS Access data to PostgrSQL data
Next
From: Robert Korteweg
Date:
Subject: MS Access data to PostgrSQL data