mysql> SELECT me.name_id, me.full_name, me.last_name, me.first_name, me.comments, account.account_id, account.account_number, account.boxfolder_id, account.name_id, substring(account.url,118,locate('&',account.url,118)-118) AS value2, account.comments, boxfolder.boxfolder_id, boxfolder.volume, boxfolder.box, boxfolder.folder, boxfolder.range, boxfolder.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 account account ON account.name_id = me.name_id LEFT JOIN boxfolder boxfolder ON boxfolder.boxfolder_id = account.account_id WHERE ( full_name REGEXP '[[:<:]]Byrne[[:>:]]' ) ORDER BY full_name ASC;
+---------+----------------------------+-----------+------------+----------+------------+----------------+--------------+---------+---------+----------+--------------+--------+------+--------+-------+----------+
| name_id | full_name                  | last_name | first_name | comments | account_id | account_number | boxfolder_id | name_id | value2  | comments | boxfolder_id | volume | box  | folder | range | comments |
+---------+----------------------------+-----------+------------+----------+------------+----------------+--------------+---------+---------+----------+--------------+--------+------+--------+-------+----------+
|    7220 | Byrne, E. & McCausland A.  | NULL      | NULL       | NULL     |       2642 | 5139           |          322 |    7220 | =b22f08 | NULL     |         NULL | NULL   | NULL | NULL   | NULL  | NULL     |
|    7221 | Byrne, G.                  | NULL      | NULL       | NULL     |       2643 | 4299           |          295 |    7221 | =b20f11 | NULL     |         NULL | NULL   | NULL | NULL   | NULL  | NULL     |
|    7222 | Byrne, John                | NULL      | NULL       | NULL     |       2644 | 6052           |          106 |    7222 | =b08f01 | NULL     |         NULL | NULL   | NULL | NULL   | NULL  | NULL     |
|    7223 | Byrne, P.                  | NULL      | NULL       | NULL     |       2645 | 396            |          425 |    7223 | =fol03  | NULL     |         NULL | NULL   | NULL | NULL   | NULL  | NULL     |
|    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)