How to convert varchar to number in sql statement?

[Skylight_lady]

Hi, i have a mysql table which is a varchar string. I have tried to get the following sql statement to work on my localhost without any luck.

 

SELECT * FROM users WHERE ID = '$ID' AND subscription <> 0 AND subscription <> 'admin' ORDER BY CONVERT(INT, subscription) DESC

 

If i use the following statement:

SELECT * FROM users WHERE ID = '$ID' AND subscription <> 0 AND subscription <> 'admin' ORDER BY subscription DESC

 

It works fine but, they are in the wrong order as i have numbers stored in the varchar and one text as shown in the sql statement above. Any advice would be appreciated.

[Pikachu2000]

This should do it; see what happens.

SELECT * FROM users WHERE ID = '$ID' AND subscription NOT IN( 0, 'admin') ORDER BY CAST( `subscription` AS UNSIGNED INT) DESC

[Skylight_lady]

Perfect. Thank you.