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: (view raw, whole thread or download thread mbox)
Lists: pgsql-php
try translate():

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


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?

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-2017 The PostgreSQL Global Development Group