Hello,
I am working on a MySQL database that lists the current competitors of the
company I work for as a part of a global intranet. At present I have a table
that contains the corporate website of our competitors. I would like to find
out what record in the table has the largest amount of characters. This way
I could possibly decrease the varchar size (currently 100) to speed up the
queries.
My table is as below.
CREATE TABLE competitor (
CompetitorsName varchar(35) not null,
Website varchar(100),
ID int auto_increment not null primary key
)
TIA.
Neil Silvester
Systems Administrator / Webmaster.
Heat and Control Inc.
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
