RE: [SQL] A search SQL query - Mailing list pgsql-sql

seems we'll fall below the bottom line: even regular expression can not
work here. Since "-" can be anywhere, no easy way out.

one way to do it is to purge your db, eliminate the "-"s in your db. then,
eliminate the "-"s before make query in you program.

On Thu, 2 Dec 1999, Tom Techoueyres wrote:

> Remember that the user will only type 'LM741CNSGS' in the form, and through
> the query, the results would bring back all 'LM741CNSGS' and all
> 'LM741CN-SGS' items.
> What actually i would like the query to do is when searching for
> 'LM741CNSGS' in the database, it will bring back all 'LM741CNSGS' parts that
> have a '-' in the part.
> 
> I hope I explained it better! :)
> 
> thanks,
> 
> Tom Techoueyres
> tom@eurobase.net
> 
> 
> > -----Original Message-----
> > From: kaiq@realtyideas.com [mailto:kaiq@realtyideas.com]
> > Sent: Thursday, December 02, 1999 5:27 PM
> > To: Tom Techoueyres
> > Cc: pgsql-sql@postgresql.org
> > Subject: Re: [SQL] A search SQL query
> >
> >
> > the bottom line: you may need to use regular expression. However, I'm not
> > sure it's performance. Also, it is not portable. So, if not really
> > required, I do not use it.
> >
> > a simple minded solution: just use "or":
> > select * from mytable where note = 'LM741CNSGS' or  note = 'LM741CN-SGS';
> >
> > the table name and filed name is not the same as yours. please give us
> > your "create table" so that we can cut/paste.
> >
> >
> > On Thu, 2 Dec 1999, Tom Techoueyres wrote:
> >
> > > Hi,
> > >
> > > I am using a cursor search using sql queries to get information from a
> > > database that has 5 fields. The search is done on one of the
> > fields which
> > > are "electronic components parts".
> > > My users usually type in the all part number they are looking for in the
> > > form.
> > > Here is the situation I have, lets say that a user is looking for part
> > > 'LM741CN-SGS', I have the follwoing queries:
> > > - select * from inventory where partno like 'LM741CN-SGS'
> > (exact search)
> > > - select * from inventory where partno like 'LM741CN-SGS%'
> > (partial search)
> > > - select * from inventory where partno like '%LM741CN-SGS%' (extended
> > > search)
> > >
> > > Now I need to create a query that when the user looks for
> > 'LM741CNSGS', the
> > > result comes back with all rows with 'LM741CN-SGS' and and all rows with
> > > 'LM741CNSGS'.
> > > What would the suggested sql query to provide that type of result?
> > >
> > > I would appreciate any feedback.
> > >
> > > Thank you,
> > >
> > > Tom Techoueyres
> > > tom@eurobase.net
> > >
> > >
> > > ************
> > >
> >
>