Maybe u can make a script that goes through all the members, skips the 0 messages 0 likes 0 trophies people, checks if the name has 5 letters, doesn't include A, I, M and where the last and second last letters are the same?
Actually that made no sense. If that was correct, anything I found earlier would be wrong so moot point.
Code:
select name from users where length(name) = 6 and messages >= 150 and substr(name, 3, 1) = substr(name, 4, 1);
Divvy1
Muffin
Jeppie
PerryJ
Pillow
Only have names up to id 281094 too.
If I want the second to last and last letter to be the same I get this
Code:
select name from users where length(name) = 6 and messages >= 150 and substr(name, 4, 1) = substr(name, 5, 1);
iiMoon
Rqbiin
zRinne
_Razz_
Andyyy
but then the "I am" part makes no sense.
Without the letters [a, i, m] there is nothing (up to id 282910).
Code:
select name from users where length(name) = 6 and messages >= 150 and substr(name, 4, 1) = substr(name, 5, 1) and not name like "%a%" and not name like "%i%" and not name like "%m";
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.