| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Becker | 2003-01-30 18:35:54 | populating db with PHP |
| Previous Message | Adrian Tineo | 2003-01-30 11:10:56 | Re: problem with select option |