|Subject||Re: [firebird-support] Speed difference between = and LIKE|
> OK, so I suppose the main thing here is that using LIKE doesn't prevent anWell, one advantage might be that you can never know for future data
> index being used.
> Maybe I didn't explain clear enough.
> Given the situation that in field1 all records starting with abcd are
> is there then any advantage to do
> field1 = 'abcde' compared to doing field1 starting with 'abcd' ?
if STARTING WITH 'abcd' returns only 'abcde' data ;-)
They are different statements, use the one that is appropriate.
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum: