Re: How do you deal with URL's?

[Robert A. Rosenberg]

At 22:38 -0300 on 06/21/2004, Sergio Salvi wrote about Re: How do you 
deal with URL's?:

Separate data from how it's displayed. I mean, create a table called
"states" with the fields "state_id", "state_name" and "state_url". Put
the data in the according field:
state_id state_name state_url
1 Alabama http://www.alabama.gov
2 Washington http://access.wa.gov
...and so on
Instead of a auto_increment state_id, go with the USPS 2 letter code 
(AL, WA, etc). That way you can pull up the state name from an 
address.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]