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;