Hi, A "dirty" solution would be to search :
field LIKE '% one %' or field LIKE 'one %' or field LIKE '% one' or field='one'; Regards, Jocelyn ----- Original Message ----- From: "Beauford.2003" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Tuesday, December 10, 2002 12:50 AM Subject: Select * From table where name Like 'help'; Help > Hi, > > Hey, did this list change their spam filters? Now every time I send an email > it gets bounced unless the word MySQL or Query is in the email. Anyway, > Please read below for a recent problem I am having. > > I want to be able to search on my database and be able to get the > following, but running into a few snags. > > If I search for the word - One - I want to see: > > Another One > One Day > One on One > Your The One > > But not: > > Fashioned > Stone > Everyone > > Also, and maybe part of the solution - is there a way for the search to be > case sensitive. > > TIA > > Beauford > > > > > > > > --------------------------------------------------------------------- > 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