title: Create mySQL table with city attribute that can only be one of three different cities
body: <p>I'm trying to write a script that creates a database using MySQL Workbench. I need to create a table with an attribute called "city". This attribute can only be Sydney, Brisbane or Melbourne and it needs to have a constraint that ensures it has no other value when data is inserted. How do I do this?</p>
  
  <pre><code>CREATE TABLE Warehouse (
      warehouseNumber int NOT NULL,
      warehouseName varchar(255),
      streetNumber varchar(255),
      streetName varchar(255),
      city varchar(255),
      suburb varchar(255),
      state varchar(255),
      postcode varchar(255),
      warehouseHeadName varchar(255),
      numberEmployees int,
  
      PRIMARY KEY (warehouseNumber)
  );
  </code></pre>