Skip site navigation (1) Skip section navigation (2)

Re: underscore

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: ryanne cruz <ryanne(dot)cruz(at)up(dot)edu(dot)ph>,"\\\"pgsql-php(at)postgresql(dot)org\\\"" <pgsql-php(at)postgresql(dot)org>
Subject: Re: underscore
Date: 2003-01-30 16:11:24
Message-ID: 20030130161124.5C4A2103EF@polaris.pinpointresearch.com (view raw or flat)
Thread:
Lists: pgsql-php
try translate():

select translate('Mary Margaret Smith',' ','_');
      translate      
---------------------
 Mary_Margaret_Smith

Cheers,
Steve


On Wednesday 29 January 2003 9:09 pm, ryanne cruz wrote:
> hi list!
>
> i have a column wherein a lot of entries has 2 or more names int it. these
> are separated by spaces. an example is: "John Doe", "Mary Margaret Smith".
> i need to replace the spaces with an underscore. any idea how to do this?
>
> thanks!
>
> ryanne
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

In response to

pgsql-php by date

Next:From: Bruce BeckerDate: 2003-01-30 18:35:54
Subject: populating db with PHP
Previous:From: Adrian TineoDate: 2003-01-30 11:10:56
Subject: Re: problem with select option

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group