How would I go about paging alphabetically? Like page one contains items beginning with A-G, page two contains items beginning with H-O, etc...? I've just hit a brick wall with this one. Googled it first thing, but wording this is kinda difficult lol.
I'm pretty sure I would use wildcards, but I only know how to do a query for one letter...not multiple.
------------------
Edit: Solved Problem. Here's the solution for anyone in the future...
Code: Select all
SELECT * FROM tablename
WHERE columnname LIKE '%[abcdefg]'