Posted by Matthew Weier O'Phinney on 05/02/05 22:58

* Ross <ross@aztechost.com>:
> Had a look at it and much easier to use LIKE with wildcards. Was unsure
> whether the query was case sensitive that is why I asked.

Missed the earlier post, so I don't know if you're using MySQL or not
(other responses indicate you probably are). If you are, REGEXP in mysql
works quite nicely, and are relatively fast (though not as fast as LIKE)
when going through smaller sets of records -- I wouldn't use it for
large sets of records, however.

--
Matthew Weier O'Phinney | WEBSITES:
Webmaster and IT Specialist | http://www.garden.org
National Gardening Association | http://www.kidsgardening.com
802-863-5251 x156 | http://nationalgardenmonth.org
mailto:matthew@garden.org | http://vermontbotanical.org

[Back to original message]