php-general | 2005051
Date: 05/02/05
- Next message: Ahmed Abdel-Aliem: "[PHP] setting condition problem"
- Previous message: Marek Kilimajer: "Re: [PHP] just going with LIKE"
- In reply to: Ross: "[PHP] just going with LIKE"
- Next in thread: Richard Lynch: "Re: [PHP] just going with LIKE"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
* Ross <ross <email protected>>:
> 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 <email protected> | http://vermontbotanical.org-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
- Next message: Ahmed Abdel-Aliem: "[PHP] setting condition problem"
- Previous message: Marek Kilimajer: "Re: [PHP] just going with LIKE"
- In reply to: Ross: "[PHP] just going with LIKE"
- Next in thread: Richard Lynch: "Re: [PHP] just going with LIKE"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

