On 12/7/05 10:57 AM, "Strong" <[EMAIL PROTECTED]> wrote:
> I want to ask for technology on retriving from a table two values in
> single request. Say, I can do (MySQL query):
> select id where name="q";
> And through DBI on say $row[0] have the id. But! How to in single
> request if I want to retrive 2 ids: for name="q" and for name="w"?
> It is a great optimization thing if I in this simple query will reduce
> DB-requests by 2. Thank You.
Select id from table where name in ('q','w');
Sean
---------------------------------------------------------------------
Web Archive: http://www.mail-archive.com/[email protected]/
http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
