# \#mysql
**URL:** https://discuss.aerospike.com/tag/mysql/74.md
[Latest](https://discuss.aerospike.com/latest.md) · [Categories](https://discuss.aerospike.com/categories.md) · [Tags](https://discuss.aerospike.com/tags.md)
---
## [Join operation in Aerospike node client](https://discuss.aerospike.com/t/join-operation-in-aerospike-node-client/4809)
**Author:** [@Nikunj\_Patel](https://discuss.aerospike.com/u/Nikunj_Patel)\
**Replies:** 1\
**Last updated:** [December 11, 2017, 5:43pm UTC](https://discuss.aerospike.com/t/join-operation-in-aerospike-node-client/4809 "2017-12-11T17:43:47Z")
Can I do join operations like SQL. Or I want to get data from two tables in single query. Which is efficient way to get records?
---
## [Can the following MySQL query be migrated to AS?](https://discuss.aerospike.com/t/can-the-following-mysql-query-be-migrated-to-as/2254)
**Author:** [@Dennis](https://discuss.aerospike.com/u/Dennis)\
**Replies:** 0\
**Last updated:** [December 11, 2015, 5:37pm UTC](https://discuss.aerospike.com/t/can-the-following-mysql-query-be-migrated-to-as/2254 "2015-12-11T17:37:34Z")
I have a MySQL table: ( post\_id varchar, user\_id varchar, time timestamp ) I’m doing: Get all post\_ids by a set of user\_ids (IN clause) Use offset and limit for pagination (however cursor based pagination will be ok a…
---
## [AND and GROUP BY with Aerospike PHP Client](https://discuss.aerospike.com/t/and-and-group-by-with-aerospike-php-client/2131)
**Author:** [@Furunomoe](https://discuss.aerospike.com/u/Furunomoe)\
**Replies:** 1\
**Last updated:** [November 18, 2015, 5:09pm UTC](https://discuss.aerospike.com/t/and-and-group-by-with-aerospike-php-client/2131 "2015-11-18T17:09:37Z")
I am currently examining aerospike for replacing my company MySQL database. Currently, in MySQL, we have a table that stores the transaction data, the table looks like this : +--------+------------+-----------+---------…