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.

$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);
}
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.