When using JOINS by the simply supplying a comma separated list of tables in
the FROM clause, is the ON argument normally associated with a join intended
to be addressed in the WHERE clause, or should ON still be used?
// Comma separated join
SELECT u.*, a.city FROM users u, addresses a WHERE u.
REGEXP?
Bastien
From: "Dwight Altman" <[EMAIL PROTECTED]>
To:
Subject: [PHP-DB] IS_NUMERIC ?
Date: Mon, 28 Nov 2005 10:01:26 -0600
Hello List,
Is there an IS_NUMERIC(aCandidateString) function in MySQL that I can run
in
a query, similar to the various PHP "is_*" functions? I can't seem to
Message-ID: <[EMAIL PROTECTED]>
Date: Sun, 27 Nov 2005 12:49:17 -0500
From: Glenn DeschĂȘnes <[EMAIL PROTECTED]>
To: php-db@lists.php.net
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="=_Part_11492_6161784.1133113757293"
Subject: Re: [PHP-DB] MySQL Update Quandry
Th
Hello
How can I compare a user password with an old /etc/shadow file from Solaris 7.
The crypt function gives an other result!
Thanks
Koen
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hello List,
Is there an IS_NUMERIC(aCandidateString) function in MySQL that I can run in
a query, similar to the various PHP "is_*" functions? I can't seem to find
it in the docs (other than a C API IS_NUM macro).
I have a field in a database with serial numbers like:
...1234
...1235
...1236-A
..
Hello *,
I have a search form and I like to add advanced search options like
"this is a search" -XXX Test
which mean,
1) "this is a search" must be in this order
2) -XXXDo not find XXX contents
3) TestAND
Does anyone has a PH