Re: just going with LIKE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



* Ross <ross@xxxxxxxxxxxxx>:
> 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@xxxxxxxxxx         | http://vermontbotanical.org

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux