mysql - How to get records with first letter that match one of three letters -
i retrieve records who's first letter match either a, b or c. should match whether caps or not.
example:
$sql = "select id, title tblname first letter of title in (a, b, c) order title asc"; any appreciated.
thanks
select id, title tblname title regexp '^[abc]' order title asc
Comments
Post a Comment