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
> 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?
You can use
- ...WHERE column LIKE '%specific text%'
- "use the regex stuff" (which is mostly slower than LIKE)
- MATCH afte
"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:
