Gender in query

Posted in

#1 by PortaTerzo
2022-06-12 at 15:30
< report >I'm sort of embarrassed to ask, but I don't feel like spending more time trying to figure it out, so...

Gender is its own data type... How do I filter out specific gender out?
#2 by Mutsuki
2022-06-12 at 15:53
< report >link

like this?
#3 by PortaTerzo
2022-06-12 at 17:08
< report >No, the browser search is very limiting. I want to use the query.
link

It should look something like this:

SELECT name, gender from chars
WHERE gender like "%f%"Last modified on 2022-06-12 at 17:09
#4 by Draconyan
2022-06-12 at 17:22
< report >Character genders can be 'm', 'f', 'b', 'unknown', for male, female, both and uknown, respectively.

So if you wanted to exclude female characters it would look like:
SELECT * FROM chars
WHERE gender != 'f'
#5 by PortaTerzo
2022-06-12 at 22:29
< report >#4 Thanks, that works.

Reply

You must be logged in to reply to this thread.