Thank you, That did the trick.
> -----Original Message----- > From: Egor Egorov [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 27, 2004 12:17 AM > To: [EMAIL PROTECTED] > Subject: Re: select command with a search? > > "Christopher Lyon" <[EMAIL PROTECTED]> wrote: > > I want to be able to search for specific text in a field and return the > > results for those rows. What is the best way to go about it? Do I use > > the regex stuff or match? > > > > It depends. > You can use LIKE, REGEXP, full-text search for those purpose: > http://dev.mysql.com/doc/mysql/en/Pattern_matching.html > http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]