Title: SQL Query Settings
Last modified: June 6, 2025

---

# SQL Query Settings

 *  Resolved [jkacher](https://wordpress.org/support/users/jkacher/)
 * (@jkacher)
 * [1 year ago](https://wordpress.org/support/topic/sql-query-settings/)
 * Something is wrong with the SQL Query settings. 
   For example I type and execute
   this:Set [@abc](https://wordpress.org/support/users/abc/) = ‘e’;Command accepted.
   But if I ask to show the variable, or make any other statement it returns Error:
   Select [@abc](https://wordpress.org/support/users/abc/);Now I can switch to MyPhpAdmin
   and it works properly, seems I need to set some SQL parameter – which one?

The topic ‘SQL Query Settings’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [jkacher](https://wordpress.org/support/users/jkacher/)
 * Last activity: [1 year ago](https://wordpress.org/support/topic/sql-query-settings/)
 * Status: resolved