HaydnH Posted October 28, 2012 Share 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 Link to comment Share on other sites More sharing options...
spursmaddave Posted October 28, 2012 Author Share Posted October 28, 2012 Would love to know what percentage of your posts contain a picture? 70% Quote Link to comment Share on other sites More sharing options...
Ebized Posted October 28, 2012 Share Posted October 28, 2012 Welcome to the 10k+ club... Quote Link to comment Share on other sites More sharing options...
spursmaddave Posted October 28, 2012 Author Share Posted October 28, 2012 Welcome to the 10k+ club... Thanks Colin, what do I get Quote Link to comment Share on other sites More sharing options...
NeilMH Posted October 28, 2012 Share 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 Link to comment Share on other sites More sharing options...
spursmaddave Posted October 28, 2012 Author Share 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 Link to comment Share on other sites More sharing options...
NeilMH Posted October 28, 2012 Share Posted October 28, 2012 You need another 713 posts pronto - well within your abilities I think Quote Link to comment Share on other sites More sharing options...
Wasso Posted October 28, 2012 Share Posted October 28, 2012 Welcome to the 10k+ club... Thanks Colin, what do I get A warning Quote Link to comment Share on other sites More sharing options...
Stew Posted October 28, 2012 Share 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 Link to comment 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.