Hi List. A quick question. I have some categories that are really long
and I would like to re-word or re-format them when I am bring data in from a
DB. Now which would be better:
Do it with PHP
Do it with MySQL
Any suggestions as to how to?
A column name: Customer --> VARCHAR
Values in Customer: "USA-North Upper ABVDFR Co. and Sons"
I would like to re-word it for example: ABVDFR Co.
I know I could use SUBSTRING or MID, or replace but the issue is since the
column is a VARCHAR, the length of the value may change from row to row, for
example: one row it maybe 20, in the next 13 and so on so forth. I also
thought that if I could use a length statement and come up with a
formula...but so far no success....any suggestions?
Thx in Adv.
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php