mysql error #1064

I just installed the MySQLi Server Behaviors and after successfully defining a database connections, I tried to run a simple query to test (Select * from users) and I get a mysql error #1064

That error usually means a bad SQL statement. I'd need FTP access and a URL to reproduce. Are you sure your connection information is correct? Are you able to test your database connection and see the table names in Dreamweaver?

Yes, I am positive the connection details are correct (I can see the tables).
The statement is correct. It runs fine in MySQL workbench. If I skip the test button and just insert, it worked. Im not sure what changed, but it seems to work now.

I have exactly the same problem,
on the other hand if we select "=" as search by filter it works.
the error comes from writing your software when we write contains
please help us

I'll look into this. It appears to be an issue with the test button, but it shouldn't cause issues once applied. I think the resulting page will function properly.