SELECT * FROM Table WHERE Fruit LIKE "banana%" Matthew Walker Ecommerce Project Manager Mountain Top Herbs
-----Original Message----- From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 12:56 PM To: Mysql List (E-mail) Subject: LIKE work around?? 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 --------------------------------------------------------------------- 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