Browse Our Pets

Query 1:

SELECT p.*, 
        CASE 
            WHEN p.status = 'available' THEN 'Available for Adoption'
            WHEN p.status = 'adopted' THEN 'Adopted'
            WHEN p.status = 'fostered' THEN 'Currently Fostered'
            ELSE p.status
        END as status_text
        
        FROM pets p 
        
        WHERE p.status = ?
        ORDER BY p.created_at DESC

Parameters:

[
    "available"
]

Query 2:

SELECT DISTINCT species FROM pets ORDER BY species

Query 3:

SELECT DISTINCT breed FROM pets WHERE breed IS NOT NULL AND breed != '' ORDER BY breed