Re: Fulltext boolean search and the asterix

[Jigal van Hemert]

Lindsey wrote:

ok thanks, then i know!


i have tried \* but that did't work, it just does the same as *.

but do you know how to use the * in regexp searches. err what i mean if i want to search for * and not use it as asterix?

The manual comes again to the rescue ;-)

Appendix G [1] tells us:



So:
SELECT 'GRANDS*N' REGEXP 'S\\*N';  ->  1

[1] http://dev.mysql.com/doc/refman/5.0/en/regexp.html

Regards, Jigal.

" To use a literal instance of a special character in a regular expression, precede it by two backslash (\) characters. The MySQL parser interprets one of the backslashes, and the regular expression library interprets the other. "

smime.p7s
Description: S/MIME Cryptographic Signature