MySQL Forums
Forum List  »  Newbie

Pattern matching problem
Posted by: Ben Wilson
Date: September 02, 2010 01:11PM

I have an issue in which I have comma-separated tickers for stocks listed in a MySQL field, for instance:

T, VZ in one entry

NTAP, AAPL in one entry

The problem is that when I query for %T%, it will bring back the second entry, even though I only wanted to pull the first entry. In other words, I want items that only match T, not NTAP. Is there any way to write a query to control for this, or do I have to redo my database?

Thanks much.

Options: ReplyQuote

Written By
Pattern matching problem
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
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.