limit 1
| From: | Jeremy Morano | Date: | Fri, 24 Aug 2001 19:30:15 +0000 |
| Subject: | limit 1 | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-64313@lists.php.net to get a copy of this message | ||
Hi,
I wondering if it was possible to use limit on part of a query and not all.
this is my query which works the way it should.
$sql = "SELECT users.names
FROM users, selection
Where users.name = selection.name and setting = 'on' limit 1
";
What I would like to do is put a limit of 1 to only this part -----> setting
= 'on' limit 1 <--------------- and not on the rest.
You see, there are many users.name that have a setting = 'on'............I
want, ALL those names , ONLY once..
How do I do this?