Hi Bennett! On Wed, 14 Nov 2001, Bennett wrote:
> I did try > select * from user where 'Bennett' LIKE emailaddress; > > but it returned 0 results; in fact, so did > select * from user where 'bennett' LIKE emailaddress; I didn't think that through too well, did I. :) See the Doc for 'Pattern Matching' regarding % and _ and such. This works: SELECT * FROM user WHERE emailaddress LIKE '%Bennett%'; > (I can't find "LIKE" documented anywhere on the > www.mysql.com/doc/ tutorial page, even though MySQL accepts it as part of > valid syntax.) Thanks for your suggestions though. Yes, LIKE is a difficult word to find because it's so common and returns too many hits. A search for 'pattern matching' returns exactly relevant hits. Gauging by the section numbers returned I think the most relevant section 3.3.4.7 is -just- off the end of the list when searching for 'like'. A search for 'select' does return that page in the list. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] --------------------------------------------------------------------- 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
