Re: RE: [PHP-DB] Searching MySQL using LIKE

Try: REGEXP 'keyword?'; //Matches Zero or one instances of 'keyword' REGEXP 'keyword+'; //Matches One or more instances of 'keyword' REGEXP 'keyword*'; //Matches Zero or more instances of 'keyword' Cheers. Russ '; On Fri, 21 Sep 2001 04:14:47 -0700 Ralph Guzman <raguzman@netraiser.com> wrote: > Postfix Users, > e need to > try and help out in any way I can. So here goes: > > Jord, > > Try using REGEXP rather than LIKE. So try something like this: > > SELECT * FROM table WHERE keywords REGEXP '%keyword%'; > > If this does not work I may have the wrong string pattern, if so, do a > search on REGEXP on the mySQL manual: > http://www.mysql.com/doc/. I'm sure > they have examples on using REGEXP. > > Good Luck. > > -----Original Message----- > From: Jordan Elver [mailto:jord@theinternetone.co.uk] > Sent: Friday, September 21, 2001 9:03 AM > To: MySQL Mailing List; PHP DB Mailing List > Subject: [PHP-DB] Searching MySQL using LIKE > > Hi, > I'm cross posting this because it's applicable to both list ;-) > > I have a table which contains a field called Keywords. The field typically > contains something similar to this "rubbish bins trash" > > I want to search this field and I'm having trouble. If someone enters "I > need > bins" then the the result will not be found. > > I started off by using SELECT * FROM table WHERE keywords LIKE '%keyword%', > but that doesn't work if you type in more than just bins. So then I tried > splitting the words entered on a space and searching for each of them like > this SELECT * FROM table WHERE keywords LIKE '%keyword1%' OR keywords LIKE > '%keyword1%'. But that returns loads of results because a lot of words > contain "is" or "it" etc. > > Can anyone help me with this one, I'm not sure what to try next? > > Cheer, > > Jord > -- > Jordan Elver > Web Developer > The InternetOne UK Ltd > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > #-------------------------------------------------------# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: r.j.michell@apu.ac.uk w: www.apu.ac.uk/webteam t: +44 (0)1223 363271 x 2331 www.theruss.com #-------------------------------------------------------#