WHERE statment with SET field.

Question

Situation:

Have a SET field called country with values

('us','uk','fr','intl')

When I go to pull the content from the db:

$sql  = "SELECT id, title, content "; 
$sql .= "FROM table_name "; 
$sql .= "WHERE country='us'";

Works fine with entries labeled only 'us' but if the entry is 'us,uk' or 'us,fr,intl' and so forth. It does not pull those. Ideas?

Thanks!

Answer 1

You'd need to use the FIND_IN_SET() function.

SELECT id, title, content
FROM table_name
WHERE FIND_IN_SET('us', country)

Answer 2

$sql  = "SELECT id, title, content "; 
$sql .= "FROM table_name "; 
$sql .= "WHERE country in ('us','uk','fr','intl')";

Answer 3

$sql  = "SELECT id, title, content FROM table_name WHERE country in (";
$countries=split(",",$whatever);
$first=1;
foreach($countries as $country){
    if(!$first) $sql .= ",";
    $sql .= "'".mysql_real_escape_string($country)."'";
    $first=0;
}
sql .= ")";