Serching db if one field contains multiple values

[2005]

I never stored multiple values in one field but it's very useful. The only problem is that I don't know how to make a script for searching if one field contains multiple values.

My form contains checkboxes. If user checks first, second and fourth box, data in db will look like this:
1, 2, 4

The same for searching. Tf user selects first and fourth checkbox, the searchterms will be:
1, 4

But it's not possible to search in this way:

select from... where languages='$searchterms '

or

select from... where languages like '%$searchterms%'

I need to find all rows where field "languages" contains values "1 and 4" (in this example) even if there are other values in this row.

I hope you understand what I mean.

Thank you for any help.

[notaloser]

before you query, explode the string with multiple values into an array, and loop the values through the query

$searchterms = "1, 4";
$pieces = explode(", ", $searchterms);

foreach($pieces as $value) {

$query = mysql_query("SELECT field FROM table WHERE field = '".$value."' ");
$rows = mysql_fetch_row($query);

echo $rows[0] // the result of the query

}

[2005]

Notaloser, thank you for your answer. Unfortunately, this doesn't work for me and I get wrong records.

Is there some way to make this search with IN ?