[SQLite] Syntax error

[Sisqo0]

i got from debugscript 3 :-   

dbPoll failed, near "WHERE":syntax error

local grp_db = dbConnect("sqlite",":Chats/Groups/groups.db")
dbQuery(getinfo,grp_db,"SELECT name FROM groups WHERE groupName = ? AND WHERE rank = ?","Sisqo","Owner")

function getinfo(q)
	if (q) then
		local p = dbPoll(q,-1)
		if (#p > 0) then
			for _,d in pairs(p) do
                outputChatBox(tostring(d["name"]))
			end
		end
	end
end

if i removed the second "WHERE" and "AND" , it would work so the question is "How to put 'WHERE' twice?"

[IIYAMA]

16 minutes ago, Sisqo0 said:

it would work so the question is "How to put 'WHERE' twice?"

You can only use WHERE once.

After that you have the operators: AND, OR and NOT at your disposal.

See these examples: https://www.w3schools.com/sql/sql_and_or.asp