How to use MySQL 'IN' Operator?
#1

pawn Code:
format(query, sizeof(query), "SELECT * FROM `arecords` WHERE PSQLID IN(%d, %d, %d)", BSub[playerid][0], BSub[playerid][1], BSub[playerid][2]);
                        mysql_tquery(dbHandle, query, "GetBloodResult", "i",playerid);

How do I get the result from this?

Essentially, I have 3 Blood Sample slots. I'm trying to check in ONE query if those 3 variables (if > 0) are in the police database to match to a record.

What is the correct way?
Reply


Messages In This Thread
How to use MySQL 'IN' Operator? - by Dokins - 17.06.2017, 04:20
Re: How to use MySQL 'IN' Operator? - by Vince - 17.06.2017, 08:33

Forum Jump:


Users browsing this thread: 1 Guest(s)