[Koha] stuck and i need a mysql clue

Nicole Engard nengard at gmail.com
Wed Nov 4 07:59:18 NZDT 2009


And the broken record -- make sure you share what you learn on the
Koha wiki SQL Report Library:
http://wiki.koha.org/doku.php?id=sql_library

Thanks
Nicole Engard
Documentation Manager

2009/11/3 Erik Lewis <elewis at ngrl.org>:
> Exactly the clue in I needed.
> Thanks
> SELECT b.biblionumber, b.author, b.title, SUBSTR(i.isbn,1,10)
> FROM biblio b, biblioitems i
> WHERE (b.biblionumber = i.biblionumber AND i.biblionumber IS NOT NULL)
> AND (b.author IS NOT NULL) AND (b.title IS NOT NULL);
>
>
> On Nov 3, 2009, at 11:13 AM, Emrys Minnig wrote:
>
> 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
>
>
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>


More information about the Koha mailing list