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

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