Jstr

mysql> explain vendors;+--------------+--------------+------+-----+---------+----------------+| Field        | Type         | Null | Key | Default | Extra          |+--------------+--------------+------+-----+---------+----------------+| id           | int(20)      | NO   | PRI | NULL    | auto_increment || company_name | varchar(255) | YES  |     | NULL    |                || contact_name | varchar(255) | YES  |     | NULL    |                || address      | varchar(255) | YES  |     | NULL    |                || city         | varchar(255) | YES  |     | NULL    |                || state        | varchar(100) | YES  |     | NULL    |                || zipcode      | varchar(25)  | YES  |     | NULL    |                || phone        | varchar(25)  | YES  |     | NULL    |                || email        | varchar(255) | YES  |     | NULL    |                || url          | varchar(255) | YES  |     | NULL    |                || category     | varchar(255) | YES  |     | NULL    |                |+--------------+--------------+------+-----+---------+----------------+mysql> explain category;+-------+---------+------+-----+---------+----------------+| Field | Type    | Null | Key | Default | Extra          |+-------+---------+------+-----+---------+----------------+| catid | int(11) | NO   | PRI | NULL    | auto_increment || name  | text    | YES  |     | NULL    |                |+-------+---------+------+-----+---------+----------------+2 rows in set (0.02 sec)mysql> select * from category;+-------+---------------------------+| catid | name                      |+-------+---------------------------+|     1 | Antiques, Liquidators     ||     2 | Appraiser, Home           ||     3 | Auto Body                 ||     4 | Carpet Cleaners           ||     5 | Dentist                   ||     6 | Dent Removal              ||     7 | Electrician               ||     8 | Financial Consultant      ||     9 | Flooring                  ||    10 | Home Inspectors           ||    11 | Insurance                 ||    12 | Landscaping               ||    13 | Mold Inspection / Removal ||    14 | Moving Companies          ||    15 | Odor Removal              ||    16 | Painter / Paper           ||    17 | Pest Inspections          ||    18 | Radon Inspections         ||    19 | Title Agency              ||    20 | Well Inspections          |+-------+---------------------------+