Comparing a string to a database entry

Unity Engine
1

I am trying to compare an existing string to data coming from a database so I can link the existing data to the data coming from the database.

I have this but it doesn’t want to work.

"select * from modelGEOmodelData where  modelGeoURL = " + AssetURI + "";

I’m getting this error and others that are similar.

SqlException (0x80131904): Incorrect syntax near '='.

How can I do this?

2

I don’t believe I’ve ever written a serious line of SQL in my life but it seems like maybe you’re missing some punctuation, based on examples I randomly found online.

Here’s one example:

That might not be your problem, but it’s a start…