Regex to run on the output of $mysql> describe {table}; to get each column's data for some other use... maybe code generation. (remove first 3 lines of mysql output)

mysql-describe-regex.rb

data = <<EODATA
| id                          | int(11)      | NO   | PRI | NULL    | auto_increment |
| physical_address            | varchar(255) | YES  |     | NULL    |                |
| physical_address2           | varchar(255) | YES  |     | NULL    |                |
| physical_city               | varchar(255) | YES  |     | NULL    |                |
| physical_state_id           | int(11)      | YES  |     | NULL    |                |
| physical_postal_code        | varchar(255) | YES  |     | NULL    |                |
| physical_country_id         | int(11)      | YES  |     | NULL    |                |
| billing_address             | varchar(255) | YES  |     | NULL    |                |
| billing_address2            | varchar(255) | YES  |     | NULL    |                |
| billing_city                | varchar(255) | YES  |     | NULL    |                |
| billing_state_id            | int(11)      | YES  |     | NULL    |                |
| billing_postal_code         | varchar(255) | YES  |     | NULL    |                |
| billing_country_id          | int(11)      | YES  |     | NULL    |                |
+-----------------------------+--------------+------+-----+---------+----------------+
EODATA
results = data.scan(/^\|{1}\s{1}(\w+)\s+\|{1}\s{1}(\w+\(?\d*\)?)\s+\|{1}\s{1}(\w+)\s+\|{1}\s{1}(\w*)\s+\|{1}\s{1}(\w+)\s+\|{1}\s{1}(\w*)\s+\|{1}/i)
results.each do |match|
  puts "-"*25
  puts match.join(" -- ")
end