0

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

Welcome to Mathematica.SE! I suggest the following:

answering questionsin your area of expertise.Also, please remember to accept the answer, if any, that solves your problem, by clicking the checkmark sign!

1Not an answer to your question, but a tip -- I use Mathematica and MySQL together every day, and I use

`SQLExecute[]`

rather than`SQLUpdate[]`

or`SQLSelect[]`

. 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. – Michael Stern – 2016-04-15T21:21:40.987@MichaelStern I do the same. I was/am very interested to go even further and systematically apply SQL to data massaging and retrieval tasks within

– Anton Antonov – 2016-05-15T14:42:18.723Mathematicain the same way the R package "sqldf" does.