> I didn't key the placename because they're not guaranteed to be >unique, but that means that a search for "Artesia" takes many (~30) >seconds to complete, which is really not very useful.
You should not use the placename as a PRIMARY KEY, but it can still have an index. You really should add a primary key to the placename table, though. To start I'd recomend the following: ALTER TABLE places ADD INDEX place_index (placename); ALTER TABLE places ADD COLUMN id int unsigned auto_increment primary key; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]