Range with Letters and Numbers

[SteveCatbert]

Hi,

 

I am working on a range script where the range consists of values ranging from 01A, 01B, 01C..... 05A, 05B.... 11A, 11B, 11C, etc.

 

Is there a way to filter out a range such as this so if I wanted to, say, select all values between 1A-5D, would that be possible? Is there a way to manipulate the range function to accomplish this?

[Jacques1]

The range() function cannot do this (unless you were to convert the strings into numbers, which is cumbersome). But you can use a for loop:

for ($str = '1A'; $str <= '5D'; $str++)
{
    var_dump($str);
}

Edited January 7, 2016 by Jacques1

[SteveCatbert]

I need to put this into a mysql query where only values between 1A and 5D would show up (including 1A and 5D). Do you know how to this could be accomplished?

[Barand]

SELECT whatever FROM mytable WHERE mycol BETWEEN '1A' AND '5D'

[SteveCatbert]

I feel like an idiot now. Thank you very much, that did it.