2 rows where season contains " fall", season contains " summer " and season contains "spring " sorted by min_full_sun

View and edit SQL

season (array)

  • fall · 2
  • summer · 2
  • spring · 2
id ideal_temp min_full_sun ▼ plant_spacing season seed_name year_produced need_to_reorder days_to_harvest is_flower num_packets indertiminate_determinate notes
14     2-3in ["spring ", " summer ", " fall"] scarlet nantes carrots 2019   65-75        
10 60-80 full sun 3-4in ["spring ", " summer ", " fall"] Jung Green yu choy 2020   40-45        

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [seeds] (
   [id] INTEGER PRIMARY KEY,
   [ideal_temp] TEXT,
   [min_full_sun] TEXT,
   [plant_spacing] TEXT,
   [season] TEXT,
   [seed_name] TEXT,
   [year_produced] TEXT,
   [need_to_reorder] INTEGER,
   [days_to_harvest] TEXT,
   [is_flower] TEXT,
   [num_packets] FLOAT,
   [indertiminate_determinate] TEXT,
   [notes] TEXT
);