Re: prepared SELECT and placeholders with NULL values

[Bruno Wolff III <bruno(at)wolff(dot)to>]

On Thu, Mar 23, 2006 at 15:24:16 -0600,
  Michael Lea <michael(dot)lea(at)gmail(dot)com> wrote:
> 
>   $s = $db->prepare('SELECT id FROM person WHERE lname = ? AND fname = ?');
> 
> But this does not, returning an empty list:
>   $s->execute('Cher', undef);

= NULL will return NULL for every row and no rows will be selected by the
WHERE clause. This is how things are supposed to work according to the
standard.

It is hard to say what you might do without knowing more about what you
are doing, but a simple possibility may be to use the empty string ('') instead
of NULL in your data.