how to query IDs ENDING with 5 in the ones digit?

[dflow]

for example:

ID=35

ID=105

[Pikachu2000]

RIGHT()

 

SELECT `id` FROM `table` WHERE RIGHT(`id`, 1) = 5

[dflow]

RIGHT()

 

SELECT `id` FROM `table` WHERE RIGHT(`id`, 1) = 5

 

thanks

[dflow]

ok it works in the phpmyadmin

 

but

when i intergrate it with :

SELECT * FROM apartments WHERE InternalSupplierID ='1' AND country_id = '20' AND city_id = '2' and Desc <>'' and RIGHT( 'ID',1 ) =5

 

i get empty results although i see results without " RIGHT( 'ID',1 ) =5" in the query that should match

[Pikachu2000]

You're using single quotes around 'id'. Those should either be replaced with `backticks` or simply removed.

[dflow]

ok it works in the phpmyadmin

 

but

when i intergrate it with :

SELECT * FROM apartments WHERE InternalSupplierID ='1' AND country_id = '20' AND city_id = '2' and Desc <>'' and RIGHT( 'ID',1 ) =5

 

i get empty results although i see results without " RIGHT( 'ID',1 ) =5" in the query that should match

You're using single quotes around 'id'. Those should either be replaced with `backticks` or simply removed.

 

cheers again

[Pikachu2000]

desc is a MySQL reserved word. Either enclose it in `backticks`, or rename the column. You should be checking for query failure, and using mysql_error() while developing . . .