in my column i have user id's ie: 141 , 510 if someone is not a member it has a IP address like 210-86-39-156.dialup.xtra.co.nz i want to select just the numbers under 10,000... how can i do this?
Are you saying that you are using one column to store either of two different types of data (a user ID integer or a IP address string)?
Yes, maybe not the best way of doing things... i'll change that
It will certainly make things easier if you can normalize things by breaking it out into separate columns. Then you could do a simple WHERE user_id < 10000 in your query; or if there may be users without a user ID number (0 or NULL value): WHERE user_id BETWEEN 1 AND 9999.
user_id
