[SQL] Check if exists

[steadyfi]

Hello

I wonder how can I check for a string if it exists in a SQL Table ? Can someone show me an example with executeSQLQuery ?

Thanks

[Bonsai]

Just use WHERE to get the value you want to check.

If it returns something useful, its existing.

[RenanPG]

qh = dbQuery(conn, 'SELECT * FROM table_name WHERE user_name = ?', user) 
local result = dbPoll( qh, -1 ) 
if type(result) == 'table' and #result > 0 then 
    print('This string already exists') 
end 

This will return all columns value from the row, replace * for a certain column.

[JR10]

dbPoll with -1 is strongly discouraged. Use callbacks instead.

[steadyfi]

Thank you all for the replies ! I got it now

[RenanPG]

No problem.