[Help] SQL Check

[steadyfi]

Hello

How can I check in a SQL Table if a column text is equal to what to a var ?

Can someone tell me if this is correct ?

Code:

test = executeSQLQuery("SELECT team FROM openteams.teams") 
if test == var then 
--code 
end 

Thanks

[Bonsai]

Like this?

  
test[1].columnName 
  

[steadyfi]

Like this?

  
test[1].columnName 
  

I don't need a table. I need to check if it the text already exists. I use it for a team script. I save all the team names in a SQL Table. I need to check if the team already exists to not have multiple teams with the same name, and I do that by checking if the TEAMNAME var is equal to any of the team names saved in the SQL Table. I hope you understand

[Bonsai]

I guess you could use WHERE to select rows with teamname == var, if the result is empty, its not existing yet.

http://www.tutorialspoint.com/sqlite/sq ... clause.htm

[steadyfi]

I guess you could use WHERE to select rows with teamname == var, if the result is empty, its not existing yet.

http://www.tutorialspoint.com/sqlite/sq ... clause.htm

Thanks.

#SOLVED