that algorithm being select * from Posts order by rand() limit ${start},${end}. just random posts would be so fun to explore
REGULAR:
SELECT "Name" FROM "Customers" WHERE "Name" LIKE "Lexi %"
lowercase and without quotes (my personal favorite):
select name from customers where name like "Lexi %"
Uppercase (This Just Feels So Incredibly Wrong):
Select Name From Customers Where Name Like "Lexi %"
SpOnGeCaSe:
SeLeCt nAmE fRoM cUsToMeRs wHeRe NaMe LiKe "Lexi %"
DENSE (AND'YES'THAT'IS'VALID'SYNTAX):
SELECT'NAME'FROM'CUSTOMERS'WHERE'NAME'LIKE'Lexi%'
the last one is just so incredibly wrong. why are the spaces optional this should be illegal