RE: Merging 2 Fields

]=> ]=> 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

Re: Merging 2 Fields

David Blomstrom wrote: --- David Rodman <[EMAIL PROTECTED]> 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? Ye

RE: Merging 2 Fields

--- David Rodman <[EMAIL PROTECTED]> 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>

Re: Merging 2 Fields

---+ 2 rows in set (0.05 sec) -Original Message- From: David Blomstrom [mailto:[EMAIL PROTECTED] Sent: Saturday, June 26, 2004 8:07 PM To: [EMAIL PROTECTED] Subject: Merging 2 Fields I think I recall a thread where someone mentioned merging two fields. If t

AW: Merging 2 Fields

David, Maybe the CONCAT() function is what you are looking for ? Freddie > -Ursprüngliche Nachricht- > Von: David Blomstrom [mailto:[EMAIL PROTECTED] > Gesendet: Sonntag, 27. Juni 2004 08:07 > An: [EMAIL PROTECTED] > Betreff: Merging 2 Fields > > I think I

RE: Merging 2 Fields

| +--+ | http://www.california.gov>California | | http://www.florida.gov>Florida | +--+ 2 rows in set (0.05 sec) -Original Message- From: David Blomstrom [mailto:[EMAIL PROTE

Merging 2 Fields

I think I recall a thread where someone mentioned merging two fields. If that can be done, I'd like to know how. For example, suppose I have a field filled with place names, next to a field filled with links: California | Florida | I'd like