Select Code to Download

mysql> describe names;
+------------+--------------+------+-----+---------+----------------+
...
| first_name | text         | YES  |     | NULL    |                |
| comments   | varchar(100) | YES  |     | NULL    |                |
+------------+--------------+------+-----+---------+----------------+

mysql> describe account;
+----------------+---------------+------+-----+---------+-------------
+---+
...
| url            | varchar(1028) | YES  |     | NULL    |             
+   |
| comments       | varchar(100)  | YES  |     | NULL    |             
+   |
+----------------+---------------+------+-----+---------+-------------
+---+

mysql> describe boxfolder;
+--------------+--------------+------+-----+---------+----------------
++
...
| range        | text         | YES  |     | NULL    |                
+|
| comments     | varchar(100) | YES  |     | NULL    |                
+|
+--------------+--------------+------+-----+---------+----------------
++

mysql> SELECT n.name_id,n.full_name,a.account_id,b.boxfolder_id,b.volu
+me,b.folder,b.range,substring(a.url,118,locate('&',a.url,118)-118) AS
+ value2  FROM names as n LEFT JOIN account AS a ON n.name_id = a.name
+_id LEFT JOIN boxfolder AS b on a.boxfolder_id = b.boxfolder_id WHERE
+ n.full_name REGEXP '[[:<:]]byrne[[:>:]]' LIMIT 10;
+---------+----------------------------+------------+--------------+--
+------+--------+-----------+---------+
...
|    7225 | Byrne, Patrick             |       2675 |          215 | 2
+3     | 6      | 1539-1596 | =b15f06 |
|    7225 | Byrne, Patrick             |       2676 |          215 | 2
+3     | 6      | 1539-1596 | =b15f06 |
+---------+----------------------------+------------+--------------+--
+------+--------+-----------+---------+

mysql> SELECT me.name_id, me.full_name, me.last_name, me.first_name, m
+e.comments, account.account_id, account.account_number, account.boxfo
+lder_id, account.name_id, substring(account.url,118,locate('&',accoun
+t.url,118)-118) AS value2, account.comments, boxfolder.boxfolder_id, 
+boxfolder.volume, boxfolder.box, boxfolder.folder, boxfolder.range, b
+oxfolder.comments FROM (SELECT me.name_id, me.full_name, me.last_name
+, me.first_name, me.comments FROM names me WHERE ( full_name REGEXP '
+[[:<:]]Byrne[[:>:]]') ORDER BY full_name ASC LIMIT 5) me LEFT JOIN ac
+count account ON account.name_id = me.name_id LEFT JOIN boxfolder box
+folder ON boxfolder.boxfolder_id = account.account_id WHERE ( full_na
+me REGEXP '[[:<:]]Byrne[[:>:]]' ) ORDER BY full_name ASC;
+---------+----------------------------+-----------+------------+-----
+-----+------------+----------------+--------------+---------+--------
+-+----------+--------------+--------+------+--------+-------+--------
+--+
...
|    7224 | Byrne, P., Estate of       | NULL      | NULL       | NULL
+     |       2646 | 396            |          425 |    7224 | =fol03 
+ | NULL     |         NULL | NULL   | NULL | NULL   | NULL  | NULL   
+  |
+---------+----------------------------+-----------+------------+-----
+-----+------------+----------------+--------------+---------+--------
+-+----------+--------------+--------+------+--------+-------+--------
+--+
5 rows in set (0.20 sec)

package Carey::Schema::Result::Name;
__PACKAGE__->table("names");
...
);
__PACKAGE__->set_primary_key("name_id");
__PACKAGE__->has_many('account','Carey::Schema::Result::Account','name
+_id');

package Carey::Schema::Result::Account;
__PACKAGE__->table("account");
...
__PACKAGE__->set_primary_key("account_id");
__PACKAGE__->belongs_to('name', 'Carey::Schema::Result::Name','account
+_id');
__PACKAGE__->has_one('boxfolder', 'Carey::Schema::Result::Boxfolder','
+boxfolder_id' );

package Carey::Schema::Result::Boxfolder;
__PACKAGE__->table("boxfolder");
...
);
__PACKAGE__->set_primary_key("boxfolder_id");
__PACKAGE__->belongs_to('account','Carey::Schema::Result::Account','bo
+xfolder_id');

#!/usr/bin/perl -w

...
    print "\n";
  }
}