List:General Discussion« Previous MessageNext Message »
From:David Blomstrom Date:June 27 2004 4:27pm
Subject:RE: Merging 2 Fields
View as plain text  
--- David Rodman <david@stripped> wrote:
> You mean something like this?
> 
> mysql> create table nads(
>     -> state varchar(50),
>     -> url varchar(100));
> Query OK, 0 rows affected (0.03 sec)

OK, you're creating a table named "nads," with fields
named "state" and "url," right?

> mysql> insert into nads values('California',
> 'http://www.california.gov');
> Query OK, 1 row affected (0.00 sec)
> 
> 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?

Or is that what you're doing here?:

> mysql> SELECT CONCAT('<A HREF=', url, '>', state,
> '</A>') as link from nads;
> +--------------------------------------------------+
> | link                                             |
> +--------------------------------------------------+
> | <A HREF=http://www.california.gov>California</A> |
> | <A HREF=http://www.florida.gov>Florida</A>       |
> +--------------------------------------------------+

So this is the "concat" method, another posted alluded
to. That's the term I remember seeing in another
thread. Thanks.



		
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail 
Thread
Merging 2 FieldsDavid Blomstrom27 Jun
  • RE: Merging 2 FieldsDavid Rodman27 Jun
    • Re: Merging 2 FieldsMichael Stassen27 Jun
    • RE: Merging 2 FieldsDavid Blomstrom27 Jun
      • Re: Merging 2 FieldsMichael Stassen27 Jun
      • RE: Merging 2 FieldsDavid Rodman28 Jun
  • AW: Merging 2 FieldsFreddie Sorensen27 Jun