Programming Forums > Web Development and Design > PHP

Xeoncross · Oct 3rd, 2006, 2:41 PM

The MySQL query I came up that gives me the results I needs seems very bulky and I was wondering if anyone else, perhaps, saw a better way to do this:

(Toggle Plain Text)

SELECT * FROM names WHERE last LIKE 'A%' OR last LIKE 'B%' OR last LIKE 'C%' OR last LIKE 'D%' ORDER BY last ASC

Gilward Kukel · Oct 3rd, 2006, 3:40 PM

(Toggle Plain Text)

SELECT * FROM names WHERE last REGEXP BINARY '^[A-D]'  ORDER BY last ASC

DaWei · Oct 3rd, 2006, 3:47 PM

Less bulky, but regex is generally less efficient for simple searches.

sykkn · Oct 3rd, 2006, 4:48 PM

this should work ... no regex ...

(Toggle Plain Text)

SELECT * FROM names WHERE SUBSTRING(last,1,1) in ('A','B','C','D')  ORDER BY last ASC

Oct 3rd, 2006, 2:41 PM	#1
Xeoncross Newbie Join Date: Aug 2006 Posts: 11 Rep Power: 0	Better way to Select from MySQL? The MySQL query I came up that gives me the results I needs seems very bulky and I was wondering if anyone else, perhaps, saw a better way to do this: (Toggle Plain Text) SELECT * FROM names WHERE last LIKE 'A%' OR last LIKE 'B%' OR last LIKE 'C%' OR last LIKE 'D%' ORDER BY last ASC SELECT * FROM names WHERE last LIKE 'A%' OR last LIKE 'B%' OR last LIKE 'C%' OR last LIKE 'D%' ORDER BY last ASC __________________ Xeoncros Website Design - Christian Cosmos - Learn PHP Free - Code 2 Design

Oct 3rd, 2006, 3:40 PM	#2
Gilward Kukel Newbie Join Date: Jun 2005 Location: Vienna, Austria Posts: 15 Rep Power: 0	(Toggle Plain Text) SELECT * FROM names WHERE last REGEXP BINARY '^[A-D]' ORDER BY last ASC SELECT * FROM names WHERE last REGEXP BINARY '^[A-D]' ORDER BY last ASC

Oct 3rd, 2006, 3:47 PM	#3
DaWei Resident Grouch Join Date: Jun 2005 Posts: 6,453 Rep Power: 10	Less bulky, but regex is generally less efficient for simple searches. __________________ Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code. Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

Oct 3rd, 2006, 4:48 PM	#4
sykkn Hobbyist Programmer Join Date: Apr 2004 Location: Texas Posts: 106 Rep Power: 5	this should work ... no regex ... (Toggle Plain Text) SELECT * FROM names WHERE SUBSTRING(last,1,1) in ('A','B','C','D') ORDER BY last ASC SELECT * FROM names WHERE SUBSTRING(last,1,1) in ('A','B','C','D') ORDER BY last ASC __________________ [ [ SykkN alloc ] initWithThePowerTo: destroyYouAll ]; /* Don't make me use it! */

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

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Slackware installation guide for Linux beginners	coldDeath	Coder's Corner Lounge	104	Jul 29th, 2007 5:40 AM
Allow user to select a directory	MegaArcon	HTML / XHTML / CSS	11	Jun 5th, 2006 9:38 AM
reloading html select boxs...is there a better way?	MegaArcon	Python	13	May 26th, 2006 4:06 AM
Tutorial - Using MySQL in C#	Darkhack	C#	12	Jan 17th, 2006 10:28 AM
Simple Perl / MySQL Problem.. pls help!	domquemo	Perl	0	Jan 11th, 2006 5:08 AM

Programming Forums > Web Development and Design > PHP

Better way to Select from MySQL?