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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
