Hello,

When I run two different SQL requests, they return same result:

SELECT part_number, description FROM part WHERE part_number LIKE
"000-1_GB-01"

and

SELECT part_number, description FROM part WHERE part_number LIKE
"000-1-GB-01"

I expect the first one returns "not found" since there's no
"000-1_GB-01"
in the part table, only "000-1-GB-01". but both returns "000-1-GB-01".
Can anyone please tell me why?
where should I go to find the course ?
Thanks in advance.

Lei

>
>When I run two different SQL requests, they return same result:
>
>SELECT part_number, description FROM part WHERE part_number LIKE
>"000-1_GB-01"
>
>and
>
>SELECT part_number, description FROM part WHERE part_number LIKE
>"000-1-GB-01"

Were you aware that _ is a wildcard character, so your first query
could match "000-1QGB-01"? Solution: if you want a literal _, escape
it.

On May 21, 3:23 pm, gordonb.vr...@burditt.org (Gordon Burditt) wrote:
> >When I run two different SQL requests, they return same result:
>
> >SELECT part_number, description FROM part WHERE part_number LIKE
> >"000-1_GB-01"
>
> >and
>
> >SELECT part_number, description FROM part WHERE part_number LIKE
> >"000-1-GB-01"
>
> Were you aware that _ is a wildcard character, so your first query
> could match "000-1QGB-01"? Solution: if you want a literal _, escape
> it.

I didn't know that. Thanks for your information. -Lei

On 21 May, 23:23, gordonb.vr...@burditt.org (Gordon Burditt) wrote:
> >When I run two different SQL requests, they return same result:
>
> >SELECT part_number, description FROM part WHERE part_number LIKE
> >"000-1_GB-01"
>
> >and
>
> >SELECT part_number, description FROM part WHERE part_number LIKE
> >"000-1-GB-01"
>
> Were you aware that _ is a wildcard character, so your first query
> could match "000-1QGB-01"? Solution: if you want a literal _, escape
> it.

And don't use LIKE where it is not needed. In this situation you
should use =