sqlite-database-integration icon indicating copy to clipboard operation
sqlite-database-integration copied to clipboard
verified publisher icon WordPress

Support GROUP_CONCAT

Open tbradsha opened this issue 2 years ago • 1 comments

The common basic usage is fairly simple to translate:

  • MySQL (docs): GROUP_CONCAT( field_name SEPARATOR 'some_separator' )
  • SQLite (docs): GROUP_CONCAT( field_name, 'some_separator' )

Technically the MySQL implementation is has more options, but I suspect the above covers the majority of uses.

tbradsha avatar Jan 05 '24 18:01 tbradsha

This should be similar to rewriting the INTERVAL keyword https://github.com/WordPress/sqlite-database-integration/blob/8a4efbecf652a2ee3c5facd31ba0542b0d397c13/wp-includes/sqlite/class-wp-sqlite-translator.php#L2213

adamziel avatar Jan 26 '24 16:01 adamziel