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