Menu
Community /Pin to ProfileBookmark
@NogDogMar 19.2010 — #
(If desired, you could change that to [b]SELECT DISTINCT[/b] to consolidate duplicate title values.)@NogDogMar 19.2010 — #Not sure what the question is, then. The only difference in the last two rows is the [b]id[/b] value. If you want that, then add it to the selection list:
If that's not the answer, then I guess I need a better question. ?
Mysql Select problem
hi there
How can select one field according to other field.
for ex i have table like below
[code=php]id name title active passive
1 tUTOR jsp active
2 tutorial PHP passive
3 tutorial PHP active
4 tutorial PHP active
here i would like to choose only PHP with active fields
Thanks for attention
Sign in
to post a comment6 Comments(s) ↴
0
@NogDogMar 19.2010 — #SELECT <span><code>title</code></span> FROM <span><code>table_name</code></span> WHERE <span><code>active</code></span> = 'active'(If desired, you could change that to [b]SELECT DISTINCT[/b] to consolidate duplicate title values.)
0
@NogDogMar 19.2010 — #Not sure what the question is, then. The only difference in the last two rows is the [b]id[/b] value. If you want that, then add it to the selection list:<i>
</i>SELECT <span><code>id</code></span>, <span><code>title</code></span> FROM <span><code>table_name</code></span> WHERE <span><code>active</code></span> = 'active'
-- or --
SELECT <span><code>id</code></span>, <span><code>name</code></span>, <span><code>title</code></span> FROM <span><code>table_name</code></span> WHERE <span><code>active</code></span> = 'active'
If that's not the answer, then I guess I need a better question. ?