get part of row name in php query

[hwoarang69]

how to get part of col name in query. for ex:

les say i have these rows in table:
id    name      last     address
1     dave      da       new york
2     rand      ra       ohio
3     random     a       new

now i want to get rows where address has a word new in it.

$s=mysql_query("SELECT * FROM 'table' WHERE address ='new'");

so output should be 1st and last row.

[tiggsy]

$s=mysql_query("SELECT * FROM 'table' WHERE address LIKE '%new%'");

$numrows - mysql_num_rows($s);
for ($i=0;$i<$numrows;$i++) {
    $temp=mysql_fetch_array($s);
    extract ($temp);
}