Need some advice on a query

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
jimdavidson
Forum Newbie
Posts: 13
Joined: Thu Jul 26, 2007 10:10 am

Need some advice on a query

Post by jimdavidson »

I'm new to mySQL an could use some advice.

I have a table "items", it has few thousand records. I want to give the user an option to pick one from from a list
by item name. To reduce the size of the list I would like to break it down alphabetically, say Aa-Am, An-Az, and so on.

My question is how to I write the query?

I'm thinking it's something like these

SELECT * FROM items WHERE substr(description,0,2) < 'An' ORDER BY description ASC

SELECT * FROM items WHERE substr(description,0,2) > 'Am' AND substr(description,0,2) < 'Ba' ORDER BY description ASC

Any help will be appreciated
jimdavidson
Forum Newbie
Posts: 13
Joined: Thu Jul 26, 2007 10:10 am

Re: Need some advice on a query

Post by jimdavidson »

Nevermind, I figured it out,

SELECT * FROM items WHERE substr(description,1,2) < 'An' ORDER BY description ASC

SELECT * FROM items WHERE substr(description,1,2) > 'Am' AND substr(description,1,2) < 'Ba' ORDER BY description ASC
Post Reply