Gender in query
|#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|
|#3 by PortaTerzo|
2022-06-12 at 17:08
|< report >No, the browser search is very limiting. I want to use the query.|
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.|
You must be logged in to reply to this thread.