Thread · Horton

Query question

Jorch <jorch@saunalahti.fi> — 2001-01-16T17:39:36Z

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

Ligia M. Pimentel <lmpc@nettaxi.com> — 2001-01-17T17:45:05Z

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

Michael J Davis <mdavis@sevainc.com> — 2001-01-17T21:44:27Z

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

Gregory Wood <gregw@com-stock.com> — 2001-01-18T14:56:30Z

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

Rob Arnold <rob@cabrion.com> — 2001-01-19T04:39:06Z

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