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"
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...
Show quoted text
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"
select * from my_table where my_field like 'A%';
"Jorch" <jorch@saunalahti.fi> wrote in message
news:3A648758.71C69867@saunalahti.fi...
Show quoted text
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"
SELECT * FROM my_table WHERE my_field LIKE 'A%';
Should do it!
Show quoted text
-----Original Message-----
From: Jorch [mailto:jorch@saunalahti.fi]
Sent: Tuesday, January 16, 2001 5:40 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Query questionHow 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"
Import Notes
Resolved by subject fallback
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
Show quoted text
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"
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
Show quoted text
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"