Find rows
SELECT * FROM ### WHERE ### = 14 AND ### = 'yes' ORDER BY ### ASC LIMIT 250
With DateTimes:
SELECT * FROM ### WHERE ### = 14 AND ### > "2019-01-01 00:00:00" AND ### < "2019-01-01 00:00:00" ORDER BY ### ASC LIMIT 250
If string contains
SELECT * FROM ### WHERE ### LIKE '%SomeText I WantToMatch%' AND ### = 'yes' ORDER BY ### ASC LIMIT 250
How many rows in a table
SELECT COUNT(*) FROM tblMyTable;
Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.