Returns random IDs (or any column) from SQL Database table, passing number of records to return, column to return, table name and where condition.
Returns list separated by {{$R$}}
Need "connection", a DB connection has already been defined.
NEWID() works in MSSQL, replace NEWID() with RAND() to use same query for MySQL
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Bold.codes
Linkedin Login
Records, Column1, Table1, Where1
Reecs = RandomRecords(10, "ID", "BlogPosts", " where status = 1")
Views 4,691
Downloads 1,417
CodeID
DB ID
Codes Required 0
Similar codes
Recent 4 by ANmarAmdeen 4
Random Codes 4