User login

MySQL WHERE ... IN (1, 4, 5) syntax

Searched words: 
mysql IN command mysql IN statement SELECT WHERE IN mysql WHERE IN IN function

For maximum ease of use, the answer is in the title.

From DevArticles Forum:

SELECT foo FROM bar WHERE foo IN (1,2)

Allegedly:

Note that the IN is an array. If you have a large amount of items it may be easier to use IN $array rather than write a long query.

Resolution

Comments

WHERE IN $array

What is the syntax for this as this - WHERE IN $array - does not work.

Thanks

the appropiate syntax is $sql

the appropiate syntax is

$sql = "
...
WHERE
[FIELD] IN ( ".implode( ',' , $array_of_numbers )."
";

Saludos

$array is php syntax

$array is php syntax

Post new comment

The content of this field is kept private and will not be shown publicly.
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
  • You can use Markdown syntax to format and style the text. Also see Markdown Extra for tables, footnotes, and more.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <blockquote> <small> <h2> <h3> <h4> <h5> <h6> <sub> <sup> <p> <br> <strike> <table> <tr> <td> <thead> <th> <tbody> <tt> <output>
  • Syntax highlight code surrounded by the {syntaxhighlighter SPEC}...{/syntaxhighlighter} tags, where SPEC is a Syntaxhighlighter options string or "class="OPTIONS" title="the title".
  • Lines and paragraphs break automatically.

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.