Text Between Strings

[TVining]

I want to remove all text in a single field that matches "Army & Air Force Hometown News
News Release

123 System St. [phone] Fax: [phone]
San Antonio, TX 78226-1848 EMail: [e-mail]

For immediate release.
"
Basically, everything before and including "FOR IMMEDIATE RELEASE" and also Anything after and including "NOTE TO EDITOR".

Simple way to put it: Only keep text between "FOR IMMEDIATE RELEASE" and NOTE TO EDITOR"

Thanks,
TV

[mwasif]

Use MySQL's string functions to accomplish this e.g. SUBSTRING() and SUBSTRING_INDEX().

[TVining]

Okay, I see.

Do you have an example? Not asking anyone to write it for me, but I need a little more... What command do I use to remove the unwanted text.

Thanks,
TV

[r035198x]

Okay, I see.

Do you have an example? Not asking anyone to write it for me, but I need a little more... What command do I use to remove the unwanted text.

Thanks,
TV

Open the link posted above and read it. It has an example for almost every mysql string function.