Efficient SQL Statement

[Hassan Shaikh]

Hi All,

Which one of the following statements is more efficient?

SELECT * FROM COUNTRY WHERE LEFT(CNNAME,1)='B';

Or

SELECT * FROM COUNTRY WHERE CNNAME LIKE 'B%';

Thanks.


Hassan 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]