[HELP] MySQL column

[-Note]

Hello can anyone help me here

I want to make this work for the staff that are in "username"and permission is "true" in my MySQL Column 

For example:

Column Name staffUser:

• value (iNote)

Column Name hasPermission:

• value (true) 

Srry forgot to paste my code!

 

function voidFunction(plr)
local query = exports.mysql:query("SELECT * FROM staff")
    for k,v in ipairs (query) do
		memberName = v.staff_name
		outputChatBox(memberName..", please don't misuse this power!", plr, 255, 255, 255)
	end
end
addCommandHandler("void", voidFunction)

 

Srry forgot to paste my code!

 

function voidFunction(plr)
local query = exports.mysql:query("SELECT * FROM staff")
    for k,v in ipairs (query) do
		memberName = v.staff_name
		outputChatBox(memberName..", please don't misuse this power!", plr, 255, 255, 255)
	end
end
addCommandHandler("void", voidFunction)

 

[Spakye]

hello,

    SELECT * FROM staff WHERE hasPermission = 'true'