[Koha] stuck and i need a mysql clue

[Emrys Minnig]

Use IS NOT NULL in your WHERE statement.   For example:
 
SELECT * FROM biblio WHERE title = "Slaughterhouse Five" AND isbn IS NOT NULL.
 
Emrys

________________________________

From: koha-bounces at lists.katipo.co.nz on behalf of Erik Lewis
Sent: Tue 03/11/2009 16:00
To: koha at lists.katipo.co.nz
Subject: [Koha] stuck and i need a mysql clue




How would I exclude NULL values from the author, title, or isbn fields 
in the query.

SELECT b.biblionumber, b.author, b.title, SUBSTR(i.isbn,1,10)
FROM biblio b, biblioitems i
WHERE b.biblionumber = i.biblionumber;


I know it should be easy, but I'm not having much luck.
_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha