NYCPHP Meetup

[Rafi Sheikh]

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
or
Do it with MySQL

Any suggestions as to how to?

Example:
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.

RS


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.