(MS Power Automate Desktop) Resolving LIKE Query Errors

Most query statements will also work with MS Power Automate if they have completed their operation with MYSQL.
However, if you put the LIKE query statement as it is, you can see that an error occurs in the conditions for LIKE.

Let's get right to the point and look at the capture screen.


Column that finds character data starting with one of the A columns in the test table.
MS Power Automate Desktop uses the % symbol for variable declaration

 

SELECT *
FROM test
WHERE A LIKE  '1%'

MS POWER AUTOMATE DESKTOP does not understand '1%' of this query.

---

Workaround

If you tie it to %%, you can recognize it again. You can look at the screenshot below.

Tie the existing % to %% to resolve the error.

SELECT  *
FROM test
WHERE A LIKE '%'1%'%'

 

 

Thank you.