An approach that has worked for me in the past and may work for you. Declare
as many parms as you can possibly need and then code the statement like
this:
SELECT * FROM someWhere
WHERE @parm1 = 123 OR @parm1 IS NULL
AND @parm2 = 345 OR @parm2 IS NULL
-- etc.
This has the desired effect and elimi
f equality.
This gets me closer, but not exactly there yet.
From: Martin Gainty [mgai...@hotmail.com]
Sent: Friday, March 27, 2009 1:58 PM
To: b...@wisper-wireless.com; mysql@lists.mysql.com
Subject: RE: Search based where claused and stored proc
Ben-
; To: mysql@lists.mysql.com
> Subject: RE: Search based where claused and stored proc
> Date: Fri, 27 Mar 2009 13:43:51 -0500
>
>
>
> Ben Wiechman
> Network Administrator
> Wisper High Speed Internet
> Office: 866.394.7737
> Direct: 320.256.0184
> C
ts.mysql.com
> Subject: [MySQL] Search based where claused and stored proc
>
> I'm working on a small project of re-implementing all of the sql for a
> web site. The task is pretty trivial but overall there are some minor
> things that I'm trying to code through.
>
I'm working on a small project of re-implementing all of the sql for a web
site. The task is pretty trivial but overall there are some minor things that
I'm trying to code through.
We've moved much of the logic over to stored procs and call them with
parameterized queries. This works well sin
