checking if a value exists in a mysql field

[beermaker74]

I need to do some checks for someof my dynamic pages. What I need to do is go thru the complete table for one field and see if a value exists. the values are either y  n or null. I only need to check for y. IS there a quick and dirty method to do this? Thanks for the help

 

[tom100]

if (mysql_num_rows(mysql_query("SELECT * FROM `tablename` WHERE `blah` = 'y')) > 0)

[beermaker74]

thanks just what i was looking for

[trq]

<?php

  // connect to db
  if ($result = mysql_query("SELECT fld FROM tbl WHERE fld = 'y'")) {
    if (mysql_num_rows($result)) {
      // y was found
    }
  }

?>