...uhm duh. My apologies. I had the LIKE switched around when I tried it and after reading through the manual and not finding anything about LIKE (it isn't mentioned as a parameter in the SELECT section) I assumed it wasn't supported. Thanks for your comments. Aaron =20
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 1:12 PM To: Rutledge, Aaron Cc: Mysql List (E-mail) Subject: Re: LIKE work around?? Work-around? LIKE should work just fine... mysql> select * from fruits where fruit_name like '%banana%'; On Thu, 7 Feb 2002, Rutledge, Aaron 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