SMS FAQ

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 column FROM table
ORDER BY RANDOM()
LIMIT 1

SELECT TOP 1 column FROM table
ORDER BY NEWID()

SELECT column, RAND() as IDX
FROM table
ORDER BY IDX FETCH FIRST 1 ROWS ONLY

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.