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 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 > > ________________________________________________________________________ > SetFile DATABASE FACTORY > > - Aplicaciones a Medida en FileMaker Pro ( Windows y Macintosh ) > > <[EMAIL PROTECTED]> <www.setfile.com/es> TEL 93 238 56 00 > > FileMaker Inc es miembro del BSA ( 900 211 048) > SetFile - FSA Partners > ________________________________________________________________________ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
