Use Like or =

2003-08-14 Thread eli
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 _

Re: Use Like or =

2003-08-14 Thread Paul DuBois
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

Re: Use Like or =

2003-08-14 Thread Andy Jackman
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