# MySQL SELECT \* from news ..?

**URL:** <https://forum.kirupa.com/t/mysql-select-from-news/45379>\
**Category:** Uncategorized\
**Created:** [March 13, 2004, 9:08pm UTC](https://forum.kirupa.com/t/mysql-select-from-news/45379 "2004-03-13T21:08:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![T\_O](https://avatars.discourse-cdn.com/v4/letter/t/cc9497/32.png) [@T\_O](https://forum.kirupa.com/u/T_O)\
**Post date:** [March 13, 2004, 9:08pm UTC](https://forum.kirupa.com/t/mysql-select-from-news/45379/1 "2004-03-13T21:08:39Z")

</div>

I would like to select from a column. a type. Soo I have like 3 diffent types. 1 2 and 3. How would i go about selecting only one type and displaying it. There in table news.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [March 13, 2004, 9:29pm UTC](https://forum.kirupa.com/t/mysql-select-from-news/45379/2 "2004-03-13T21:29:12Z")

</div>

so i would like first to only select the rows with type nr. 2  
then display those rows that have nr. 2 as type.