sqlite3: How to use SELECT + WHERE to search a random row?

Question

Eg. In the Table1 there is a column ColName, some of the items in ColName are "Mike".

The code to search one of the them:

searchString = " SELECT * FROM Table1 WHERE ColName = 'Mike' "
cur.execute(searchString).fetchone()

The Problem: The code above allways gives me the first row, where "Mike" in ColName appears.

I actually want, by everytime running the sqlite code, to get a random search result from the column ColName, whose value is "Mike". How could I change the code?

Thanks for the help!

score 0 · Answer 1 · answered Jan 28 '18 at 05:34

0

If you want a random value, then you need to iterate over cur.execute(searchString) for some random amount, then extract the column(s).

fetchone() always returns the top result

The alternative includes trying to randomly sort the query results in SQL

answered Jan 28 '18 at 05:34

OneCricketeer

179,855
19
132
245

1

Just use `ORDER BY RAND()` – Tom Jan 28 '18 at 05:38
1

Sure. I'm not super familiar with the sqlite functions – OneCricketeer Jan 28 '18 at 05:40

sqlite3: How to use SELECT + WHERE to search a random row?

1 Answers1