On Sat, 1999-09-18 18:02:52 -0400, James Manning wrote:
> [ Saturday, September 18, 1999 ] Martin Ramsch wrote:
> > And such a REGEXP could be
> > WHERE field REGEXP '[[:<:]]keyword[[:>:]]';
> Is this case sensitive or not?
REGEXP in MySQL is always case sensitive (though the internal regex
library could do case-insensitive matches, so it wouldn't be hard to
add IREGEXP), but ...
> For whichever it is, what's the method for specifying the other? :)
... you always can use UPPER() or LOWER() (whatever you like better)
on the other side:
WHERE LOWER(field) REGEXP '[[:<:]]keyword[[:>:]]';
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26 E4 EC 80 58 7B 31 3A D7