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 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. 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
Archived
This topic is now archived and is closed to further replies.