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 http://marc.theaimsgroup.com/?l=php-db ------------------------------------------ /* 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
