SQL query help

  CutNpaste 19:02 08 Feb 2007
Locked

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!!!

  fitshase 19:32 08 Feb 2007

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%'

  CutNpaste 20:18 08 Feb 2007

ur a superstar!!!!

Massive THANK YOU!!!

  fitshase 07:35 09 Feb 2007

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.

Elsewhere on IDG sites

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