Re: Compare a given value with multiple values field
| From: | Natalie Leotta | Date: | Sat, 16 Sep 2006 19:02:41 +0000 |
| Subject: | Re: Compare a given value with multiple values field | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-42357@lists.php.net to get a copy of this message | ||
I'm not sure I understand your question, but my interpretation would be
solved like this
select * from table where variable in (select id from tablefield1)
I hope this helps you!!
Natalie
On 9/16/06, Hassan <aldoyh@yahoo.com> 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