Question about using SELECT and WHERE

[shawjames]

Hello,
Okay, I am a beginner to mysql, and I need some help.

I am trying to select a row in my database by searching for a part of one field. This should be easy, but I cant figure it out...

So, here is what I have right now for my mySQL_query:

SELECT name, phone, email FROM mydb WHERE code = 'ABC'

Now, I want to select everyone that has 'ABC' in the first 3 characters of their 'code' field. The code field data is in the form ABC123. So I want a match when test value matches the first 3 characters of the field.

Any easy way to do this?
I am using PHP to run my SQL queries.

Thanks!!
-Newbie

[cgraz]

if you want to search the field code where the first 3 letters are ABC, use

SELECT name, phone, email FROM mydb WHERE code LIKE 'ABC%'

The % sign is a wildcard means any characters.

Cgraz

[gtibok]

SELECT * FROM `table` WHERE code LIKE 'ABC%'

[gtibok]

I was 1 sec late😃