Re: Re: Search MySQL and Match Whole Words
| From: | Kenneth Dombrowski | Date: | Fri, 23 Apr 2004 00:47:31 +0000 |
| Subject: | Re: Re: Search MySQL and Match Whole Words | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-184325@lists.php.net to get a copy of this message | ||
On 04-04-22 19:48 -0400, Matt Palermo wrote:
> That will work if there is only one word in the column I'm searching, but
> the columns I'm searching are in paragraph form, so the = will not work
> there if I want to just match one word from the whole paragraph...
>
http://dev.mysql.com/doc/mysql/en/Regexp.html
[[:<:]]
[[:>:]]
These markers stand for word boundaries. They match the beginning and end
of words, respectively. A word is a sequence of word characters that is not
preceded by or followed by word characters. A word character is an alphanumeric
character in the alnum class or an underscore (_).