Get last conversation in mysql table in facebook style

Get last conversation in mysql table in facebook style :

If you want to get conversation(chat) of users ie . the last message in the conversation use the following query it will give the last message in the conversation :
suppose you have following chat table

SELECT 
*
FROM (

SELECT *
FROM chat AS c
WHERE c.from = '138'
OR c.to = '138'
ORDER BY c.id DESC
) AS m1
WHERE m1.is_active !=0
GROUP BY LEAST( m1.from, m1.to ) , GREATEST( m1.from, m1.to )
ORDER BY m1.id DESC
LIMIT 0 , 10

---

Where c.to=2 or c.from=2 is current user’s id .
And is_active is deletion status.

Add Comment

📖 Read More

• 1. Mysql find duplicate records in table
• 2. Sql create table with primary key
• 3. Mysql create table primary key autoincrement example
• 4. Get zip codes in radius Mysql query
• 5. SQL Prevent Duplicate INSERT - MySql

• 6. Get list of MySQL user accounts
• 7. Can't connect to local MySQL server through socket '/var/mysql/mysql.sock'
• 8. MySQL Grant all privileges on database