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?
[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?
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