Postgres Pro
Downloads
Home   >   mailing lists

Thread: Query question

Query question

From
Jorch
Date:
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"

RE: Query question

From
Colin Taylor
Date:
SELECT * FROM my_table WHERE my_field LIKE 'A%';
Should do it!

> -----Original Message-----
> From: Jorch [mailto:jorch@saunalahti.fi]
> Sent: Tuesday, January 16, 2001 5:40 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Query question
>
>
> 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"
>
>

Re: Query question

From
"Gregory Wood"
Date:
SELECT * FROM my_table WHERE my_field LIKE 'A%';

Greg

----- Original Message -----
From: "Jorch" <jorch@saunalahti.fi>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, January 16, 2001 12:39 PM
Subject: Query question


> 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"
>
>

Re: Query question

From
"Michael J Davis"
Date:
select * from my_table where my_field like 'A%';

"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"
>
>

Re: Query question

From
"Ligia M. Pimentel"
Date:
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"
>
>

Re: Query question

From
"rob"
Date:
SELECT * FROM my_table WHERE my_field LIKE 'A%';

--rob


----- Original Message -----
From: "Jorch" <jorch@saunalahti.fi>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, January 16, 2001 12:39 PM
Subject: Query question


> 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"
>
>
>