WIldcard Search

[michaelk46]

I have a MySQl database that I am trying to run a search on using wildcard characters. If I use the following string:

SELECT * FROM testtab WHERE lname=‘Andrews’;

I get a list of every person with the last name Andrews… But if I use this:

SELECT * FROM testtab WHERE lname=‘A%’;

I get an empty set…

Am I mistaken in my belief that % is a wildcard character or am I doing something else incorrectly?

[r937]

@michaelk46

Am I mistaken in my belief that % is a wildcard character or am I doing something else incorrectly?

no you’re not, and yes you are

… WHERE lname LIKE ‘A%’

[michaelk46]

@r937

no you’re not, and yes you are

… WHERE lname LIKE ‘A%’

Thank You very much that was driving me nuts…