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?

Thank you in advance.

kkrueger


---------------------------------------------------------------------
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

Reply via email to