Re: Why is this query killing me?

To my knowledge and my experience, case doesn't matter for MySQL default settings. Please goto www.inc21.com, at coverage box, put in "cisco", or "Cisco", both will return San Francisco. Could you please give us some record example which you think should be returned as the query result. Alex > On Wed, 17 Oct 2001 13:55:08 -0400 "Jeff Lewis" <jeff@hyrum.net> wrote: > > > When I was leaving a space it was returning results like: > > > > carpets, caring etc when we're only trying t get the words themselves. So > > this wahy w're grabbing the word car with a space on either side :) > > > > mysql supports UPPER/LOWER funtions, UPPER/LOWER the sql value and support > the compared value as upper/lower, too. > > SELECT pub, class, startdate, adtext FROM classifieds WHERE (UPPER(pub)='KWR' OR > UPPER(pub)='GUE') AND (startdate<'17-Oct-01') AND ( UPPER(adtext) LIKE > '% GERMAN %' OR > UPPER(adtext) LIKE '% CAR %'); > > > The problem we're having though is with case and multiple search keywords. > > > > Jeff > > ----- Original Message ----- > > From: "Alex Shi" <chpshi@netvigator.ca> > > To: "Jeff Lewis" <jeff@hyrum.net>; <php-general@lists.php.net> > > Sent: Wednesday, October 17, 2001 1:52 PM > > Subject: Re: [PHP] Why is this query killing me? > > > > > > > Why you leave a space between the keyword and '%' on each side of it ? > > > > > > Alex > > > > > > ----- Original Message ----- > > > From: "Jeff Lewis" <jeff@hyrum.net> > > > To: <php-general@lists.php.net> > > > Sent: Wednesday, October 17, 2001 1:45 PM > > > Subject: [PHP] Why is this query killing me? > > > > > > > > > I am creating an advanced search with PHP and pulling from mySQL and here > > is > > > an example of a query I have built: > > > > > > SELECT pub, class, startdate, adtext FROM classifieds WHERE (pub='KWR' OR > > > pub='GUE') AND (startdate<'17-Oct-01') AND ( adtext LIKE > > > '% German %' OR > > > adtext LIKE '% car %'); > > > > > > Now with this, it returns an ad about German sheppard pups but doesn't > > > return any of the dozens of ads about cars. Now if I use german in lower > > > case it won't return the German Sheppard pups ad as well!! > > > > > > What am I doing wrong? > > > > > > Jeff > > > > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-general-help@lists.php.net > > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > -- > ------------------------------------------------------- > intraDAT AG http://www.intradat.com > Wilhelm-Leuschner-Strasse 7 Tel: +49 69-25629-0 > D - 60329 Frankfurt am Main Fax: +49 69-25629-256 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >