Quote
Ben
Columns: ID, Date, Sector, Tickers, Title, Link, Body
So really each row is like an article that is tagged with a variety of tickers. Would this kind of implementation still work with your table structure?
Yes, it still works. Just replace the userId in my previous example with your ID column and you should be set.
Quote
Ben
I'd imagine I'd create a separate table of tickers then somehow join that table to my article table?
Yes, like in my example. You could call the table Tickers rather than Stocks if you prefer.
Quote
Ben
Also, I have a few hundred articles in the database... might there be some way to extract the tickers that are associated with each one into the new database?
This is a little more tricky. I'm sure there are some solutions already provided that will split the string into a table that you could modify for your needs. I may play with it in the morning if you haven't found one yet.
Quote
Ben
and one FINAL question -- do you have a donate button or something? Your help is fantastic.
Hmm, I'm not sure if it's appropriate or not, but I actually do have
a donate button from an old app I wrote. Of course, the app itself happens to be down right now. ;-)
HTH,
Chad