OpenOffice.info

Code: Alles auswählen

SELECT 
    "Pflanzen".*, 
    IFNULL( "Pflanzen"."Pflanzentyp", '' ) AS "T", 
    IFNULL( "Pflanzen"."Vorhanden", '' ) AS "K" 
FROM
    "Pflanzen" 
WHERE  
    IFNULL( "Pflanzen"."Pflanzentyp", '' ) = IFNULL( ( SELECT "Filter_1" FROM "Filter" ), "T" ) 
    AND 
    IFNULL( "Pflanzen"."Vorhanden", '' ) = IFNULL( ( SELECT "Filter_2" FROM "Filter" ), "K" )  
    AND 
    LOWER ( "Botanischer Name" ) LIKE IFNULL( ( SELECT '%' || LOWER ( "Suchbegriff" ) || '%' FROM "Filter" ), LOWER ( "Botanischer Name" ) ) 
    OR 
    LOWER ( "Deutscher Name" ) LIKE ( SELECT '%' || LOWER ( "Suchbegriff" ) || '%' FROM "Filter" ) 
    OR 
    LOWER ( "Standort" ) LIKE ( SELECT '%' || LOWER ( "Suchbegriff" ) || '%' FROM "Filter" ) 
    OR 
    LOWER ( "Herkunft" ) LIKE ( SELECT '%' || LOWER ( "Suchbegriff" ) || '%' FROM "Filter" ) 
    OR 
    LOWER ( "Pflanzdatum" ) LIKE ( SELECT '%' || LOWER ( "Suchbegriff" ) || '%' FROM "Filter" ) 
    OR 
    LOWER ( "Blütezeit" ) LIKE ( SELECT '%' || LOWER ( "Suchbegriff" ) || '%' FROM "Filter" ) 
ORDER BY 
    "Botanischer Name" ASC