Hi everyone,i got a database table ful of entries.I wanted an SQL query that would onyly extract data that start with 'A' or 'B' etc.plz help!!! cant fins any reference!!!
Say your table is called "users" and the field you are searching is "username", then your query would be:-SELECT username FROM users WHERE username LIKE 'A%'
ur a superstar!!!!Massive THANK YOU!!!
No probs.Make sure you tick the box to say the thread is resolved.
This thread is now locked and can not be replied to.
Best phone camera 2017
Stunning new film posters by Hattie Stewart, Joe Cruz & more
iPad Pro 10.5in (2017) review
28 astuces pour profiter au mieux de votre iPhone
© Copyright 2017 IDG UK. All Rights Reserved.