On Monday 19 January 2004 18:21, lisi wrote:

> 2) Solution: Add the leading slash to each entry in the db (MySQL)
>      Problem: How do I do this with a query without having to change each
> one manually? I know I can change the link field using UPDATE but how would
> I tell MySQL to change the entry to / + entry? Each entry is obviously
> different. Using a plus makes MySQL think it's mathematical addition and
> sets the field to 0. The field type is varchar.

Use MySQL's CONCAT() function.

Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
Search the list archives before you post
Subtlety is the art of saying what you think and getting out of the way
before it is understood.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to