Re: Open Source databases

[Steven Pritchard <steve@silug.org>]

On Thu, Feb 12, 2004 at 11:07:06AM -0500, Drews, Jonathan* wrote:
> 3) Access' ability to search for incomplete names is just awful. Say I want
> to search for 2,4-dichloro compounds in the inventory. I only have the ? and
> * wildcards to do it with and they do not seem to work well. The Microsft
> database does a terrible job when searching on partial names. Can MySQL or
> Postgres do better? I should hope so.

SQL syntax for that is '%', so you'd select on a field like
'%2,4-dichloro%'.

Steve
-- 
steve@silug.org           | Southern Illinois Linux Users Group
(618)398-7360             | See web site for meeting details.
Steven Pritchard          | http://www.silug.org/

-
To unsubscribe, send email to majordomo@silug.org with
"unsubscribe silug-discuss" in the body.