How do i query integer values of varchar field?
Field has '0000111' and i need to query for the integer value of that, aka 111
mysql type format question
Moderator: General Moderators
-
Shendemiar
- Forum Contributor
- Posts: 404
- Joined: Thu Jan 08, 2004 8:28 am
-
Shendemiar
- Forum Contributor
- Posts: 404
- Joined: Thu Jan 08, 2004 8:28 am
Re: mysql type format question
Got it
Code: Select all
$setelit_q = fetch_query("SELECT * FROM shs_data_setelit WHERE CAST(sarjanumero AS SIGNED)<='{$_POST['max']}' AND CAST(sarjanumero AS SIGNED)>='{$_POST['min']}' ");