HaydnH Posted October 28, 2012 Posted October 28, 2012 Would love to know what percentage of your posts contain a picture? select count(*) from tableName where username='SMD' and message like '*[img*' ? That will be 100% as it will pick up the Pic in Signature Doubt it. When you update a sig it updates all your posts with the new sig - I doubt it does that to every message in the DB. It will probably update just one signature entry that can then be added to each post at display time using a join. Quote
spursmaddave Posted October 28, 2012 Author Posted October 28, 2012 Would love to know what percentage of your posts contain a picture? 70% Quote
spursmaddave Posted October 28, 2012 Author Posted October 28, 2012 Welcome to the 10k+ club... Thanks Colin, what do I get Quote
NeilMH Posted October 28, 2012 Posted October 28, 2012 I wondered whether you were aiming to ramp up a bit to get to and maintain 10% of your clock mileage - it would be a most handsome challenge Quote
spursmaddave Posted October 28, 2012 Author Posted October 28, 2012 I wondered whether you were aiming to ramp up a bit to get to and maintain 10% of your clock mileage - it would be a most handsome challenge Now there is a thought, 10 posts for every mile in the Zed not far off I think I am on 107,400 ish miles.... That reminds me I need to call Scott next week Quote
NeilMH Posted October 28, 2012 Posted October 28, 2012 You need another 713 posts pronto - well within your abilities I think Quote
Wasso Posted October 28, 2012 Posted October 28, 2012 Welcome to the 10k+ club... Thanks Colin, what do I get A warning Quote
Stew Posted October 28, 2012 Posted October 28, 2012 Well Dave, on this momentous occasion I'd like to offer you a prize on behalf of the club. You can choose from an all expenses paid trip away or A smurfette Take your pick! Quote
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.