SQL SELECT ALL BUT {array}

Question

I want to get all the results but the ones in the array $valuesnew.

$query = "SELECT * FROM venue
        WHERE venue_id IN ($valuesnew)";

Is there a fast way to do this?

$valuesnew contain string or is numeric ?

shatheesh
– shatheesh

2014-05-14 09:56:56 +00:00
Commented May 14, 2014 at 9:56 — shatheesh
– shatheesh, Commented May 14, 2014 at 9:56

MD SHAHIDUL ISLAM · Accepted Answer · 2014-05-14 10:00:28Z

1

$query = "SELECT * FROM venue
    WHERE venue_id NOT IN ('".implode("','",$valuesnew)."')";

answered May 14, 2014 at 10:00

MD SHAHIDUL ISLAM

14.5k6 gold badges84 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

D. Schalla · Accepted Answer · 2014-05-14 09:56:42Z

0

SELECT * ROM venue WHERE NOT venue_id ($valuesnew)

NOT Operator negates your condition.

answered May 14, 2014 at 9:56

D. Schalla

6554 silver badges9 bronze badges

Comments

웃웃웃웃웃 · Accepted Answer · 2014-05-14 09:59:33Z

0

Maybe:

$query = "SELECT * FROM venue
        WHERE venue_id **NOT** IN ($valuesnew)";

edited May 14, 2014 at 9:59

웃웃웃웃웃

12k15 gold badges63 silver badges95 bronze badges

answered May 14, 2014 at 9:57

Fernando

3091 silver badge5 bronze badges

Comments

웃웃웃웃웃 · Accepted Answer · 2014-05-14 09:59:56Z

0

select * from table where column NOT IN ('value1','value2','value3');

edited May 14, 2014 at 9:59

웃웃웃웃웃

12k15 gold badges63 silver badges95 bronze badges

answered May 14, 2014 at 9:57

cfv1000

4633 silver badges10 bronze badges

3 Comments

Laurent W. Over a year ago

Values must be surrounded by quotes !

cfv1000 Over a year ago

no. Strings need to be surrounded by quotes. Read more about data types

Laurent W. Over a year ago

He uses the variable $valuesnew, so it may lead to SQL injections if you don't know what is actually in $valuesnew. Although it's not sufficient to secure the query...

Collectives™ on Stack Overflow

SQL SELECT ALL BUT {array}

4 Answers 4

Comments

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related