Re: [PHP-DB] Compare a given value with multiple values field

[Natalie Leotta]

I'm not sure I understand your question, but my interpretation would be
solved like this

Advertising

select * from table where variable in (select id from tablefield1)

I hope this helps you!!

Natalie

On 9/16/06, Hassan <[EMAIL PROTECTED]> wrote:

Hi My Best List, I have a field in a table contains "3,31,11,10" (let say
tablefield1) and I have a given value which I need to check if it exists in
that list.

  I've tried:
  SELECT * FROM table WHERE 3 IN ( tablefield1 );

  Any ideas?


---------------------------------
Get your email and more, right on the  new Yahoo.com