I have a column in a database called Description and I want to strip out all the individual words that exist in this column into a separate table and count the occurances.
As part of this process the column with be turned to UPPER(Decsription)
so for example
amazon and ebay exist
returns temp table with 2 fields
Please note, the following is a variant of the technique contained in the comment by ste5an above.
There are countless variations of "split string" functions, here's another that I believe to be efficient
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes.
Assigning simple products to configurable: We assigned simple products…