What sql clause can be use for displaying rows by a colum content?

[co.ador]

Need to know what SQL clause can categorize rows according to a row content?

I want to display a set of rows according to a culumn x content...

[r937]

SELECT column1, column2, ...
  FROM daTable
 WHERE columnx = 'foo'

if this isn't what you were looking for, could you be a bit more specific please?

[co.ador]

That's what exactly I am looking for...



how would formulate the same question I asked for but in others terms where is more compatible or Standard for others to understand?

[r937]

i think the terminology you want is called filtering

you want to return a set of rows based on a filter of a certain column value