MySQL Forums
Forum List  »  Newbie

Re: Pattern matching problem
Posted by: Ben Wilson
Date: September 02, 2010 04:24PM

Chad,

Thanks so much; will do some research into data normalization.

Just FYI (sorry to bug you further) the table structure looks like this:

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?

I'd imagine I'd create a separate table of tickers then somehow join that table to my article table?

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?

and one FINAL question -- do you have a donate button or something? Your help is fantastic.


Thanks again...

Options: ReplyQuote


Subject
Written By
Posted
September 02, 2010 01:11PM
September 02, 2010 02:33PM
September 02, 2010 02:46PM
September 02, 2010 03:10PM
Re: Pattern matching problem
September 02, 2010 04:24PM
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.