rahuul Posted August 4, 2010 Share Posted August 4, 2010 hi friends, I have a table which contain some data about data, it includes a zipcode field which contain coma (,) septated values....... like (94232,94234,94235,........) now i have a variable the also contain range of zip code in this format: ('94209','94211','94229') pls can some one advice how i can fetch all the records matching all the zipcode in my variable with zipcodes in my data base......... i tried 'IN' clause......... but not wording............. pls help................. thanks Quote Link to comment https://forums.phpfreaks.com/topic/209753-how-to-find-use-in-clause/ Share on other sites More sharing options...
fenway Posted August 5, 2010 Share Posted August 5, 2010 That's just poor data storage design -- there is no simple facility for handling this is the data are stored that way. Quote Link to comment https://forums.phpfreaks.com/topic/209753-how-to-find-use-in-clause/#findComment-1095545 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.