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.

Comments

Your email address will not be published. Required fields are marked *