]=>
]=> mysql> insert into nads values('Florida',
]=> 'http://www.florida.gov');
]=> Query OK, 1 row affected (0.00 sec)
]=
]=I'm a little confused here. I'm slightly more familiar
]=with manipulating PHP than MySQL. It looks like your
]=suggestion is a permanent fix. It just occurred to me
]=that it would be nice if I had the option of
]=displaying Florida as plain text or as a link.
]=
]=But if I do this, Florida will always be linked,
]=right? Also, it looks like you have to do this
]=operation for each row - California, Florida, etc. Is
]=there a simple command that merges two entire columns?
Part of the confusion might be that many mail clients, including yours and
mine, automatically re-display URL's as links. SO where I wrote:
insert into nads values('Florida', 'www dot florida dot gov')
our ever-helpful email software insisted on reformatting the URL field as a
link, which as you say is what you're trying to do in the first place.
I was just putting in sample values to parallel the database you were
describing.
The terminology you're using is not quite accurate - you are not asking to
merge two columns. If that's what you want to do, you can create a new
database using the output of the CONCAT command I suggested, and then
replace your existing database with the new one. But I believe you're
asking how to display the contents of two columns, interspersed with some
text, in the output of a query. That's not merging.
If you're more familiar with PHP than MySQL you can do exactly the same
thing using PHP's string concatenation capabilities.
-- David
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
