Explore our sites

Stack Exchange
tour help careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 2 down vote favorite

This is an example of my table:

|..id.|.class...|.group....|..name....|
|..5..|....1....|.....A....|....XX....|
|.19..|....1....|.....B....|....XX....|
|.12..|....2....|.....A....|....XX....|
|.28..|....2....|.....B....|....XX....|
|..8..|....3....|.....A....|....XX....|
|.50..|....3....|.....B....|....XX....|

It has about 30 rows per class and group. What I'm trying to do is to fetch all data after the row | 12 | 2 | A | XX |. Can't just state "where class > 2" since there are still some rows with class and group 2A that I need to be in the select.

Is there a way to do that, from SELECT or maybe a Fetch() argument in PHP & Mysql

Thanks!

share|improve this question
 
Yes, there are about 30 rows with the same class and group. Let's say I need to start to fetch or select in the middle of that class and group. –  Frexius Jun 6 at 20:14
 
how do you know then? If there's no explicitly discriminating data you have to go manually excluding a bunch of ids. Is there any valid alphabetic exclusion on the names? I mean, within the 2-A group, do you want to start from a given name ascending/descending? –  Sebas Jun 6 at 20:15
 
The name, yes, I know the specific id and name from where I want to start the selection. id=12 class=2 group='A' name='Marcus', and the selection is "order by class,group,name asc". –  Frexius Jun 6 at 20:26
 
how many different groups are there? –  Sebas Jun 6 at 20:32
add comment

3 Answers

up vote 0 down vote accepted

Try this:

SELECT * FROM `table`
WHERE
    CONCAT(`CLASS`, `GROUP`, `NAME`) >= '2AMarcus'
share|improve this answer
 
I've tried it, but, doesn't that second part need to be in a subquery or something? –  Frexius Jun 6 at 20:58
 
As long as no names in this class and group start with a letter before 'M' this could work. –  StaticVoid Jun 6 at 21:00
 
Shure it shoulds, but can't get any rows, I think it has something to do with the CONCAT within the same query... may be. –  Frexius Jun 6 at 21:14
 
could you show an extract of your database please? (a real one) –  Sebas Jun 6 at 21:44
 
'Finally make it work by removing the ' in concat, "concat(class,group,name)>'2AMarcus'. Thanks a lot guys; StaticVoid, Sebas & Friko, I really appreciate it. –  Frexius Jun 7 at 3:59
show 3 more comments
up vote 0 down vote

Select all ids and loop through them creating a comma-delimited list in PHP of the ids after 12 is found. Then do your select where id in ().

Or

Create the list of ids to exclude until 12 is found. Then do select where id not in ().

share|improve this answer
 
Ok, that sounds as a workin solution. 'Will try the 2nd one, since there are about 70 ids before id=12, whereas after id12 there are about 300 more. =/ –  Frexius Jun 6 at 20:38
add comment
up vote 0 down vote

It looks like you need some work on normalizing tables, out of sql sentences. If you need the rows after Class 2 Group A Name Marcus, it says to me that something occur in real life from that point in the time, an event, so, i would add a new column for timestamp or for another data for that event, and then back to sql sentences and use that new column for the apropiate SELECT / WHERE.

share|improve this answer
 
Indeed, there's a new column on the table, and need this query to set their values in a php loopin. Timestamp would be a useful reference. Thx –  Frexius Jun 7 at 1:47
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.