List:General Discussion« Previous MessageNext Message »
From:Jesse Sheidlower Date:September 12 2002 6:51pm
Subject:Re: newbie query question
View as plain text  
On Thu, Sep 12, 2002 at 11:46:40AM -0700, Kip Krueger wrote:
> 
> I need to query a mysql db in the following fashion ...
> 
> "find me all records whose column 'n' have the letters 'XY' as the first two
> characters."  where column 'n' is just a short string
> 
> to clarify ...
> 
> if column 'n' has the value "YR12345" don't get that record.
> if column 'n' has the value "XY44445" get me that record.
> if column 'n' has the value "XY33456" get me that record.
> 
> so I am here ...
> 
> "select * from thetable where BLAHBLAH"
> 
> what is BLAHBLAH?

n like 'XY%';

Jesse Sheidlower
Thread
newbie query questionKip Krueger12 Sep
  • Re: newbie query questionJesse Sheidlower12 Sep