Web MySQL Selecting Users with a value

[matthieu503]

Here is a mysql command to find out who is a GM on your server.
You probably already know the command though. xD

SELECT name
FROM `characters`
WHERE gm > 0

You can obviously change it around to suit your needs

SELECT name
FROM `characters`
WHERE gm = 1

That would make it so it selects all characters with the GM Level of 1. (Change characters to accounts if you want.)

SELECT `level`, `name`, `str`, `dex`, `luk`, `int`
FROM `characters`
WHERE level = 200

This would make it find all the level 200's along with the stats of them.

SELECT `name`, `banned`
FROM `accounts`
WHERE banned = 1

Lists the banned people from the server.

If you need the codes for listing any others, just post here and i'll try an reply asap.
PS: Instead of making it three lined, you can merge it to one line (Ex: SELECT name FROM `characters` WHERE gm > 0)

 

[greenelfx]

It would be much easier to link to a very simple mySQL tutorial...