I've found the docs on how to select a list of rows from a table were
all the records have a last name starting with 'W%'.
select * from table where last_name LIKE 'W%'
What I'd like to do is pull a list of records where there is a range of
last names; say from A - F.
select * from table where last_name LIKE 'A%' AND last_name LIKE 'F%' -
The above code I've tried for this doesn't seem to work as I'd expect it
I've even done
select * from table where last_name LIKE 'A%' AND LIKE 'F%'
Can anyone provide some details or insights on how to accomplish this?
Thanks. Much appreciated.
pgsql-general by date
|Next:||From: Clayton Vernon||Date: 2001-04-26 22:55:07|
|Subject: caching/ virtual file systems|
|Previous:||From: Doug McNaught||Date: 2001-04-26 22:35:39|
|Subject: Re: JDBC speed question.|