Re: matching empty column

[Alan Hodgson <ahodgson(at)simkin(dot)ca>]

On Thursday 24 August 2006 10:27, Srinivas Iyyer <srini_iyyer_bio(at)yahoo(dot)com> 
wrote:
>  tar_id | mid   | seq_id | lscore
> --------+-------+--------+--------
>   32014 |       |  50473 |    814
>   32015 |    67 |  50473 |    814
> The mid column is empty in certain places. how can I
> search if there are empty spaces in mid.
>

select tar_id from table where mid is null;

(assuming it's a numeric and not a text field set to '')

-- 
Alan