Re: [PHP] possible to use eregi instead of LIKE
Jay Blanchard wrote: [snip] you understood John [/snip] Well, there you go. At least I gave a PHP answer on this, a PHP list. ;) You are my hero. ;) -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] possible to use eregi instead of LIKE
[snip] you understood John [/snip] Well, there you go. At least I gave a PHP answer on this, a PHP list. ;) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] possible to use eregi instead of LIKE
you understood John "John Nichel" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Jay Blanchard wrote: > >> Why you'd want to do it this way beats me, the overhead is a lot bigger >> than doing it in the query. > > > I _think_ he was asking if he could use some sort of pattern matching in > the query itself. Of course, it's Monday, and I may not have understood > the question at all. ;) > > > -- > John C. Nichel > ÜberGeek > KegWorks.com > 716.856.9675 > [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] possible to use eregi instead of LIKE
you understood John "John Nichel" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Jay Blanchard wrote: > >> Why you'd want to do it this way beats me, the overhead is a lot bigger >> than doing it in the query. > > > I _think_ he was asking if he could use some sort of pattern matching in > the query itself. Of course, it's Monday, and I may not have understood > the question at all. ;) > > > -- > John C. Nichel > ÜberGeek > KegWorks.com > 716.856.9675 > [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] possible to use eregi instead of LIKE
[snip] I _think_ he was asking if he could use some sort of pattern matching in the query itself. Of course, it's Monday, and I may not have understood the question at all. ;) [/snip] True. He was pretty specific about eregi though. Perhaps he'll let us know when he does whatever it is he is doing. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] possible to use eregi instead of LIKE
Jay Blanchard wrote: Why you'd want to do it this way beats me, the overhead is a lot bigger than doing it in the query. I _think_ he was asking if he could use some sort of pattern matching in the query itself. Of course, it's Monday, and I may not have understood the question at all. ;) -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] possible to use eregi instead of LIKE
Ross wrote: Is it possible to use eregi instead of LIKE to filter mysql queries? This would be in the MySQL manual. http://dev.mysql.com/doc/mysql/en/pattern-matching.html -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] possible to use eregi instead of LIKE
[snip]
Is it possible to use eregi instead of LIKE to filter mysql queries?
If so can someone do a quick example?
[/snip]
$sql = "SELECT foo, bar FROM table ";
$result = mysql_query($sql, $connection);
while($row = mysql_fetch_array($result)){
if(eregi('glorp', $row['foo']){
echo $row['bar'] . "\n";
}
}
Why you'd want to do it this way beats me, the overhead is a lot bigger
than doing it in the query.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
