title: How to get only the data with slash and the number behind it?
body: <p>i have the following table and data</p>
  
  <pre><code>CREATE TABLE arch (
  id INT NOT NULL,
  arch_number VARCHAR(30) NOT NULL,
  PRIMARY KEY (id)
  );
  
  INSERT INTO arch 
  (id, arch_number) 
  VALUES 
  (1,"AN 50"),
  (2,"AN 50/0"),
  (3,"AN 50/1"),
  
  (4,"AN 51/0"),
  (5,"AN 51/1"),
  
  (6,"AN 52/1"),
  
  (7,"AN 53/2");
  </code></pre>
  
  <p>I want to select only those arch_numbers that have <strong>only</strong> slashes with numbers behind them. That means in this example I want to get AN 51,AN 52 and AN 53. AN 50 should be ignored completely. </p>
  
  <p>My Sql doesnt work like this:</p>
  
  <pre><code>select * from arch where arch_number like '%/%'
  </code></pre>
  
  <p>With this I will get every AN including AN 50. However, in this case AN 50 should be ignored because the row with id=1 has one without a slash and number.</p>
  
  <p>How do I do this?</p>