TEENFRONT Posted April 3, 2009 Share Posted April 3, 2009 Hey thanks for reading! Im after a little help building a query to pull info on players. $query = "SELECT games_won, games_played, userrating, profiledata, profileID, usernick FROM gamezer_users_1 WHERE banned !='1' and userstatus ='1' and profiledata !='' ORDER BY userrating DESC LIMIT 50"; is my current query but where i have this AND profiledata !='' i want to change it to soemthing like AND profiledate !='XX::XX:YY' to explain, i have a profiledata field that sets the avatar number, there sex and there country flag. so the profile data field wuld output this "01:ML:UK" or "05:FM:US" but sometimes if they dont fill out there country flag it will return this for example "02:ML:" i want to select the users that have this fully filled out so the select query would have to make sure that profiledata contained the 3 sets of info... is this possible? Many thanks for any help thrown my way Link to comment https://forums.phpfreaks.com/topic/152432-query-help-please/ Share on other sites More sharing options...
fenway Posted April 3, 2009 Share Posted April 3, 2009 You can use a REGEXP to match... but you shouldn't be storing data this way. Link to comment https://forums.phpfreaks.com/topic/152432-query-help-please/#findComment-800593 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.