Hi,
I have a question about using LIKE or equal.
I mean, comparing two strings with exact coincidence, without case
sensitive, which is better? Or are they the same? Do they work equal?
For Instance.
"abc"="abc"
Or
"abc" LIKE "abc"
I use Mysql 4.0.12.
Thanks in advanced.
Eli
_
At 16:53 +0100 8/5/03, eli wrote:
Hi,
I have a question about using LIKE or equal.
I mean, comparing two strings with exact coincidence, without case
sensitive, which is better? Or are they the same? Do they work equal?
For Instance.
"abc"="abc"
Or
"abc" LIKE "abc"
I use Mysql 4.0.12.
Thanks
Eli,
Use = for exact matches and LIKE for partial matches using a wild card
e.g. WHERE column_name LIKE "ab%" will match 'ab', 'abc' and 'ABC' but
not 'acb'.
Regards,
Andy
eli wrote:
>
> Hi,
>
> I have a question about using LIKE or equal.
>
> I mean, comparing two strings with exact coincidenc