Ozeki NG SMS Gateway

SMS FAQ

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


Most popular


If you are insterested in how to setup automated SMS notifications, you should apply one of the following configurations:

SMS through HTTP requests
SMS from E-mail
SMS from the command line
SMS using txt files


If you are a software developer you can proceed to adding SMS functionality to your source code by clicking on one of the following links:

PHP SMS example
C# SMS example
ASP SMS example
SQL SMS example
Delphi SMS example

If you would like to send and receive SMS messages from MS Office applications, please check out the following links:

Send SMS from MS Excel
Send SMS from MS Outlook
Check out Ozeki SMS Client