I'm using Mathematica, and accessing mysql through mysql (Connector/J).
When I try to update a field in my table using WHERE
statement, all the rows get updated
SQLUpdate[conn2, "Table", {"pos"}, {"Value1"}, Equal[SQLColumn["word"], "Value2"]]
SQLSelect[conn2, "Recipe.OptOutWordInIngredient"]
I thought it had to do with not using SQLStringMatchQ
.
However, when I use SQLStringMatchQ
SQLSelect[conn2, "Table", SQLStringMatchQ[DatabaseLink`SQLColumn["word"], "value"]]
I get the following error:
The value SQLStringMatchQ[acid ,value] cannot be converted to a value in an SQL statement.*
Any help will be appreciated
SQLExecute[]
rather thanSQLUpdate[]
orSQLSelect[]
. This way I can test the SQL directly in the mySQL workbench and make sure it's doing what I want before I put in in Mathematica. $\endgroup$