MySQL LIKE String Comparisons
Posted: Wed Oct 10, 2007 9:31 am
HI
in a MySQL statement I am doing a
so that the rows whos "column" data starts with "A" will be returned.
However this is not happening...in fact what is happening is that results are being returned that have "a" and "dam" but not "Adam"
What will cause the statement to act like this?
Kendall
in a MySQL statement I am doing a
Code: Select all
WHERE [column] LIKE '%A'However this is not happening...in fact what is happening is that results are being returned that have "a" and "dam" but not "Adam"
What will cause the statement to act like this?
Kendall