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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 

#-------------------------------------------------------#
                                
  "Believe nothing - consider everything"       
  
  Russ Michell
  Anglia Polytechnic University Webteam
  Room 1C 'The Eastings' East Road, Cambridge
  
  e: [EMAIL PROTECTED]
  w: www.apu.ac.uk/webteam
  t: +44 (0)1223 363271 x 2331

  www.theruss.com
                        
#-------------------------------------------------------#


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to