hello, i have a table called checkout, this has a row called products which has contains a python dictionary data, like
http://pastie.org/1082137 {products: [{productId: 123, productName: APPLE, productPrice: 2.34, productUrl: http://appple-fruits.net, productDescription: "nice juicy apples"}, {productId: 333, productName: ORANGE, productPrice: 4.21, productUrl: http://appple-fruits.net, productDescription: "nice juicy oranges"}, ...]} what will be the correct way to make a search on this data, for example if i want to search for a range of products with a price between €2 - €4 is this the correct way to store this type of data? thanks norman would i have to create a temporary table for each serialized value and then make my query on this? -- ˙uʍop ǝpısdn p,uɹnʇ pןɹoʍ ǝɥʇ ǝǝs noʎ 'ʇuǝɯɐן sǝɯıʇ ǝɥʇ puɐ 'ʇuǝʇuoɔ ǝq s,ʇǝן ʇǝʎ %>>> "".join( [ {'*':'@','^':'.'}.get(c,None) or chr(97+(ord(c)-83)%26) for c in ",adym,*)&uzq^zqf" ] ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
