Re: unique problem?
[EMAIL PROTECTED] wrote: UPDATE shpr_rcvr SET directions = 'No. ' where directions = '#'; That should do it :) Thanks for the responce however it does not work. Nothing gets change probably becasue no directions columns are ='#' there are just a lot of them with '#' in the field among many characters. If it did change something I fear it would change all of the text in the columns to 'No.' which would send me into a rage. If I am missing something please let me know. And if anyone else might know how I can solve this dilema, I would appreciate the input. Richard Reina writes: I have a table shpr_rcvr that stores info about locations where things are shipped to and from. Each record has a text field called DIRECTIONS that contains directions on how to get to the location. Often in the directions column the # sign is used to help describe and exit number off the highway. For example Take I-55 south to exit # 269. When I put text with # sign in into a latex document, latex rejects it ( won't format it ). I cannot find a work around in latex so I was wondering if someone can recommend a query that will search each directions column in the table and replace # with No.. Can anyone help? Richard --- Message sent via mail archive tracking system located at http://www.mysqldeveloper.com/lists/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: unique problem?
I think this is more what you are looking for UPDATE shpr_rcvr SET directions = REPLACE(directions,'#','No. ' where directions = '#'; -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 5:26 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: unique problem? [EMAIL PROTECTED] wrote: UPDATE shpr_rcvr SET directions = 'No. ' where directions = '#'; That should do it :) Thanks for the responce however it does not work. Nothing gets change probably becasue no directions columns are ='#' there are just a lot of them with '#' in the field among many characters. If it did change something I fear it would change all of the text in the columns to 'No.' which would send me into a rage. If I am missing something please let me know. And if anyone else might know how I can solve this dilema, I would appreciate the input. Richard Reina writes: I have a table shpr_rcvr that stores info about locations where things are shipped to and from. Each record has a text field called DIRECTIONS that contains directions on how to get to the location. Often in the directions column the # sign is used to help describe and exit number off the highway. For example Take I-55 south to exit # 269. When I put text with # sign in into a latex document, latex rejects it ( won't format it ). I cannot find a work around in latex so I was wondering if someone can recommend a query that will search each directions column in the table and replace # with No.. Can anyone help? Richard --- Message sent via mail archive tracking system located at http://www.mysqldeveloper.com/lists/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: unique problem?
SELECT REPLACE(DIRECTIONS, '#', 'No.') FROM shpr_rcvr WHERE etc. -- Greg Johnson -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED]] Sent: Monday, December 31, 2001 1:23 PM To: [EMAIL PROTECTED] Subject: unique problem? I have a table shpr_rcvr that stores info about locations where things are shipped to and from. Each record has a text field called DIRECTIONS that contains directions on how to get to the location. Often in the directions column the # sign is used to help describe and exit number off the highway. For example Take I-55 south to exit # 269. When I put text with # sign in into a latex document, latex rejects it ( won't format it ). I cannot find a work around in latex so I was wondering if someone can recommend a query that will search each directions column in the table and replace # with No.. Can anyone help? Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php