Paul DuBois wrote:
At 10:49 +0100 11/8/05, Jigal van Hemert wrote:Lindsey wrote: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?" 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. "In this case, * is to be used as a special character, you don't want to match it literally.
Paul,Lindsey wrote: "i want to search for * and use it as asterix". I interpreted this as wanting to match the '*' literally...
Regards, Jigal.
smime.p7s
Description: S/MIME Cryptographic Signature