query help please

[TEENFRONT]

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

[fenway]

You can use a REGEXP to match... but you shouldn't be storing data this way.