Opening MySQL table from Microsoft Access

[PeDa]

I have the following string:

SELECT * FROM tbtimes WHERE (eEvent LIKE '%align=\'center\'%') ORDER BY eOrder

which behaves as expected (finds records containing: align='center') when run from phpMyAdmin.

However the following in Microsoft Access gives VBA error 3075: Syntax Error (Missing Operator) in Query Expression (eEvent LIKE '%align=\'center\'%')

Set rst = dbf.OpenRecordset("SELECT * FROM tbtimes WHERE (eEvent LIKE '%align=\'center\'%') ORDER BY eOrder")

What am I doing wrong here? (general procedure works fine in other cases)

 

[PeDa]

Answered my own question (Access and MySQL escape mixed up). Should be:

SELECT * FROM tbtimes WHERE (eEvent LIKE '%align=''center''%') ORDER BY eOrder