I have these tables.
Users ( id,name,etc )
Coments : ( id , comment )
How do I do this kind of query:
I thought in one thing like this but I cant figure it out.
Example: Select * from users order by id desc in (select count (id)
from
comments)
Expected result:
List of users:
* User1
See comments
_name%" part_of_name appears at the begining
M.Mamedov
- Original Message -
From: "Muhammed Mamedov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 2:00 PM
Subject: Re: [PHP-DB] SQL question
> It should be as follows
try
SELECT * FROM x_table WHERE name LIKE "%part_of_name%"
-Original Message-
From: Constantin Brinzoi [mailto:[EMAIL PROTECTED]
Sent: 11 December 2003 11:52
To: [EMAIL PROTECTED]
Subject: [PHP-DB] SQL question
I know it is possible to search a database like this:
SELECT * FR
On 11 December 2003 11:52, Constantin Brinzoi wrote:
> I know it is possible to search a database like this:
>
> SELECT * FROM x_table WHERE name="%part_of_name%"
>
> but I don't know for sure the correct command.
>
> Could you tell me the right syntax?
SELECT * FROM x_table WHE
It should be as follows:
SELECT * FROM x_table WHERE name Like = "%part_of_name%"
Hope this helps,
M.Mamedov
- Original Message -
From: "Constantin Brinzoi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 1:51 PM
Subject: [PHP-DB] SQL question
> I know it
you can do it by using distinct function ..
Do:
SELECT DISTINCT(city) FROM addresses;
Gurhan
-Original Message-
From: Kevin Diffily [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 2:05 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] SQL Question
Hello,
I have a simple SQL Ques
SELECT DISTINCT city FROM addresses;
-Original Message-
From: Kevin Diffily [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 1:05 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] SQL Question
Hello,
I have a simple SQL Question. I would like to take the column city in
database add
