[SOLVED] selecting numeric values

[krv]

hello,

I am trying to select only certain numbers from a table.

Example:

I have a parts table one of the rows in skew #'s

the skews are from 1000 to 9000

how would i select just 2000's and 8'000s?

thanks

[Maq]

Something like (syntax may be off):

 

SELECT part_num FROM table WHERE (part_num > 1999 AND part_num  7999 AND part_num 
 

You could use 2 between clauses as well.

[krv]

ha oh yeah duh...

i was trying to do something with substr()

Thanks man.

[Maq]

Sure, I'm pretty sure my syntax is off, but I'm sure you'll figure that out soon enough.  Post any more problems, if not mark as solved please.  Good luck.

[krv]

weird so tried doing it and i did different numbers then the example im getting data like:

96541-1

96542-1

96543-1

96544-1

96545-1

96546-1

96547-1

96548-1

96549

96565

96566

96567

96600

96602

96603-1

96604-1

96605-1

96607

96608

96694

 

any functions to clean that up in sql?

[Maq]

any functions to clean that up in sql?

 

Yes.  Can you post the relevant code?

[krv]

<?php

//23/12/2008

include("includes/config.php");

 

$sql = "SELECT part FROM products WHERE part >6999 AND part <8000 OR part >8999 AND part >10000";

$result = mysql_query($sql)or die(mysql_error());

while($row=mysql_fetch_array($result)){

echo $row['part']."<br>";

}

?>

[krv]

figured it out using part BETWEEN '6000' AND '6999'

thanks for your help

[Maq]

After thinking about your problem I thought that between would be more suitable.  Glad you got it working, please, if your issue is resolved mark as solved