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
