You don't want to use LIKE in mysql - or have you not read about LIKE in the fine mysql manual??
If you use LIKE you will also need to use a % sign signify which bit is the variable bit. This is because mysql allows you to say if the variable bit is at the start or the end or both. LIKE 'banana%' would give you what you want, but it sounds like you should read the manual a bit more. cheers, noel On Friday, February 08, 2002 6:56 AM, Rutledge, Aaron [SMTP:[EMAIL PROTECTED]] wrote: > I am trying to query the database for records that have the same > sequence of starting characters--such as banana1 and banana2 and have a > result set returned that contains everything that starts with banana. > Any way to do this? I think I would use LIKE in other types of > databases, but I was wondering if there was a work around for MySQL. > Thanks, Aaron > > --------------------------------------------------------------------- > 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 > > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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
