Keyword search and replace based table wide

[CJSwed]

I have a table that looks like this...

Shall we call this table Product-Table

Description	Template	Show-back-one-section-name	Date Added	yst-my-parent
See the [Brand] [model no] Leather Case	page2	1	4/22/2010	[Brand]-[model no]
See the [Brand] [model no] Headset and enjoy your music	page2

What I am trying to do is have an external table that will have the brand in one column and model no in another column and update this Product-table

So maybe a table called Model-Table and inside this model will be a column called Brand and in that brand column it will say Apple.
Model-Table

Brand
Apple

So then every instance of [brand] will be replaced by Apple.

Any ideas?

 

[CJSwed]

I may of posted this in the wrong forum,sorry. What I am trying to do is create an SQL query to replace the [brand] into the product-table from model-table.

Feel free to move this if I posted in the wrong section. Sorry for the inconvenience.

Chris