SQL code...if NOT.... - TalkPHP

Account Login

Latest Articles

The basic usage of PHPTAL, a XML/XHTML template library for PHP

by awuehr on 11-10-2008 in Tips & Tricks

Vulnerable methods and the areas they are commonly trusted in.

by Village Idiot on 11-04-2008 in Classes & Objects

Simple way to protect a form from bot

by codefreek on 10-23-2008 in Basic

The Basics On: How Session Stealing Works

by wiifanatic on 09-12-2008 in Security & Permissions

How to keep your forms from double posting data

by drewbee on 07-03-2008 in Tips & Tricks

IRC Channel

IRC Speech Bubble

Join the friendly bunch on IRC...
(#TalkPHP on Freenode)

...Also available via a web interface.

See this thread for information on the TalkPHP Free Hugs Initiative™. Subject to availability.

Associates

Associates

TalkPHP » SQL code...if NOT....

Reply

Search this Thread

04-02-2009, 10:04 PM	#1 (permalink)
allworknoplay The Gregarious Join Date: Feb 2009 Location: New York Posts: 645 Thanks: 64	SQL code...if NOT.... Ok, is there any way to make this query better? It seems like I should be able to somehow use less "AND"... Code: SELECT * FROM users WHERE user_id != '5' AND user_id != '6' AND user_id != '9' AND user_id != '3';

04-02-2009, 10:50 PM	#2 (permalink)
Salathe Moderateur Join Date: Apr 2007 Posts: 1,393 Thanks: 5	First, why are you wrapping integers in quotes? Second, and more to the point, to use less (no!) `AND`s you could use `…WHERE user_id NOT IN (5, 6, 9, 3)`

04-02-2009, 10:56 PM #3 (permalink)

allworknoplay

The Gregarious

Join Date: Feb 2009

Location: New York

Posts: 645

Thanks: 64

allworknoplay is on a distinguished road

Default

Quote:

Originally Posted by Salathe

View Post

First, why are you wrapping integers in quotes? Second, and more to the point, to use less (no!) ANDs you could use …WHERE user_id NOT IN (5, 6, 9, 3)

Thank you!!

Yes I suppose using quotes turns the numbers into strings right?
Or is that just a PHP thing?

allworknoplay is offline

Reply With Quote

04-02-2009, 11:08 PM	#4 (permalink)
Salathe Moderateur Join Date: Apr 2007 Posts: 1,393 Thanks: 5	Yes, it's just more work for the MySQL engine to do as I assume your user_id values are integers.

The Following User Says Thank You to Salathe For This Useful Post:

allworknoplay (04-02-2009)

Old

04-02-2009, 11:16 PM

#5 (permalink)

allworknoplay

The Gregarious

Join Date: Feb 2009

Location: New York

Posts: 645

Thanks: 64

allworknoplay is on a distinguished road

Default

Quote:

Originally Posted by Salathe

View Post

Yes, it's just more work for the MySQL engine to do as I assume your user_id values are integers.

thanks, yes they are of "INT" value....

I will have to keep this in mind...

allworknoplay is offline

Reply With Quote

Reply

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SQL Injection and mysql_real_escape_string	Durux	General	61	01-29-2013 12:20 PM
Rating system sql code	Orc	General	23	01-29-2013 11:53 AM
Tips to Improve Your Coding and Projects	Village Idiot	Tips & Tricks	45	12-03-2012 07:46 AM
Writing Clean Code	Village Idiot	Tips & Tricks	10	06-25-2012 12:35 PM
SQL injections protection	Rendair	Tips & Tricks	23	12-11-2007 03:59 PM

All times are GMT. The time now is 03:24 PM.

Inactive Reminders By Icora Web Design