Help for this page

Select Code to Download

Select or download this

use Data::Dumper;
print GetNodes({name => "hello",type => "god", color => "greeen"});
...
    $sql .= " AND " .join(" = ",@LastWhere) . ";";
    return $sql;
}

Select or download this

SELECT md1.node_id
 FROM `meta_data` as md1,`meta_data` as md2,`meta_data` as md3
...
 AND md3.name = "name"
 AND md3.value = "hello"
 AND md1.node_id = md2.node_id = md3.node_id;