My mistake, I assumed the space was just for clarity and not really meaningful, but since it is between the ' ' it makes sense that is. I tried a few variations on this and think I have found what I need - where title like binary '%$var%. Notice the key word 'binary' which makes the world of difference.
>From the tests I have run this will find the occurrence of any word that begins with a capital and then matches any remaining characters. So if I search for One it will fine One Day, Day One, This One Day - however, if I search for On it will also find On The Water and Your On Third. The only thing I could do is to add a space after $var, but them partial searches won't be found. i.e. searching for beaufor will not find beauford. Until I can find a better way, one of these will suffice. Thanks for your correction as I did miss the space thing. Beauford ----- Original Message ----- From: "Jocelyn Fournier" <[EMAIL PROTECTED]> To: "Beauford.2003" <[EMAIL PROTECTED]> Sent: Monday, December 09, 2002 9:31 AM Subject: Re: Select * From table where name Like 'help'; Help > No it doesn't, since I introduce a space between % and "one". So stone will > not be returned :) > > Regards, > Jocelyn > ----- Original Message ----- > From: "Beauford.2003" <[EMAIL PROTECTED]> > To: "Jocelyn Fournier" <[EMAIL PROTECTED]> > Sent: Monday, December 09, 2002 2:26 PM > Subject: Re: Select * From table where name Like 'help'; Help > > > > That is what I am using, however, it is not as detailed as I need it to > be. > > Like I said in my original question, I don't want to get 'stone' when I > > search for 'one', and using LIKE does exactly this. > > > > Thanks, Beauford > > > > > > ----- Original Message ----- > > From: "Jocelyn Fournier" <[EMAIL PROTECTED]> > > To: "Beauford.2003" <[EMAIL PROTECTED]>; "MySQL List" > > <[EMAIL PROTECTED]> > > Sent: Sunday, December 08, 2002 7:57 PM > > Subject: Re: Select * From table where name Like 'help'; Help > > > > > > > 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 > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- 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
