jasonc Posted August 23, 2009 Share Posted August 23, 2009 i wish to search my data for all entries that starts with userid: i have tried SELECT * FROM `stats`WHERE `text` LIKE '%userid:%' but nothing shows what is the right way to do this please Link to comment https://forums.phpfreaks.com/topic/171497-find-all-entries-starting-with-userid-from-a-table/ Share on other sites More sharing options...
trq Posted August 23, 2009 Share Posted August 23, 2009 SELECT * FROM `stats`WHERE `text` LIKE 'userid%'' If nothing shows, then the data doesn't exist. Link to comment https://forums.phpfreaks.com/topic/171497-find-all-entries-starting-with-userid-from-a-table/#findComment-904377 Share on other sites More sharing options...
fenway Posted August 25, 2009 Share Posted August 25, 2009 Even faster if you use COUNT(*). Link to comment https://forums.phpfreaks.com/topic/171497-find-all-entries-starting-with-userid-from-a-table/#findComment-905940 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.