Autoreply database

Can I return a random row from a database table when an SMS comes in?
 

Yes, you have to create a query in the autoreply SMS script file that returns a random row.

You can return a random row using the ORDER BY part of the SQL selec that is used to query the response. Each database server provides random ordering, but each requires different SQL syntax. Here is the syntax you can use:

Select a random row with MySQL:

SELECT column FROM table
ORDER BY RAND()
LIMIT 1

Select a random row with PostgreSQL:
SELECT column FROM table
ORDER BY RANDOM()
LIMIT 1

Select a random row with Microsoft SQL Server:
SELECT TOP 1 column FROM table
ORDER BY NEWID()

Select a random row with IBM DB2
SELECT column, RAND() as IDX
FROM table
ORDER BY IDX FETCH FIRST 1 ROWS ONLY

Select a random record with Oracle:
SELECT column FROM
( SELECT column FROM table
ORDER BY dbms_random.value )
WHERE rownum = 1

Can I execute more then one SQL statements if an SMS comes in?

 

Yes, you can put multiple SQL commands into the Autoreply script.

The autoreply script can execute several SQL statements when an SMS comes in. Each SQL statement must be written on a single line. You can use this functionality to update data inside your database based on the contents of an incoming message, and then you can execute a SELECT query to return the results in a response SMS message.

More information