MySQL Forums
Forum List  »  Newbie

Re: Pattern matching problem
Posted by: Chad Bourque
Date: September 02, 2010 08:55PM

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.

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.

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.

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. ;-)


Options: ReplyQuote

Written By
September 02, 2010 01:11PM
September 02, 2010 02:33PM
September 02, 2010 02:46PM
September 02, 2010 03:10PM
September 02, 2010 04:24PM
Re: Pattern matching problem
September 02, 2010 08:55PM
September 03, 2010 08:37AM
September 07, 2010 03:25PM
September 07, 2010 04:39PM
September 07, 2010 06:13PM
September 07, 2010 07:08PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.