Update one column with a substr of another

[akelabanda]

Hello

I'm having a problem with an incorrect datafeed received.

Following is an example.

product_name column has this.
W880i Silver T-Mobile FLEXT 35 18 months

I now want to extract 'W880i Silver' which appears before T-Mobile and update the model_number column. This string can vary from record to record. But there is a pattern.

Another example:
C300 Virgin Mobile PAY AS YOU GO

Here I need 'C300' before 'Virgin Mobile'.

I would like to know how to capture the prefix while searching for a pattern like 'T-Mobile' and update another column model_number with the prefix.

Unable to figure out how to do this. Any help would be greatly appreciated.

Many thanks

Raj

UK's best mobile deals online

http://www.bargainmobileshop.com

 

[akelabanda]

Ok. Looked at MySQL reference manual and figured out how to do it.

Here it is:

update mytable set model_number = substring_index(product_name,' T-Mobile ',1) where network = 'T-Mobile';

This worked beautifully.

UK's best mobile deals online

http://www.bargainmobileshop.com