At 8:43 AM +1000 9/20/01, Neil Silvester wrote:
>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.
SELECT MAX(LENGTH(Website)) FROM competitor
You might also look up PROCEDURE ANALYSE() in the manual.
>
>Neil Silvester
>Systems Administrator / Webmaster.
>Heat and Control Inc.
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
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
