Difference between LIKE and = operator

[ravikumar.drk]

For query with sql, how do you select all the records from a table named "persons" where the value of the column "firstname" is "peter"? 1 select * from persons where firstname like 'peter' 2 select * from persons where firstname='peter' 3 select [all] from persons where firstname='peter' 4select [all] from persons where firstname like 'peter' whats the correct ans.

Before u r writing these type of queries, remember one point.

In case of Like condition u have top mention '%' symbol, For Ex.
select * from persons where firstname like 'Peters%';
In case of = condition u have no need to mention any thing but u have to give Exact value for that field, For Ex.
select * from persons where firstname = 'Peters';

If the data is with that same name, the data will display.

I think it's correct answer for ur query.

[rajivgupta780184]

Both "=" and "like" operator are use to search the data within table. But "=" operator are usede when you are confident about the inputs you have given bcoz query will search that specific value in the table if it will get it will display output otherwise......no output will be there but if you are using like '****%" operator then it will be searching for all the data that are matching your inputs... Enjoy..........

Thanks
rajiv gupta
yogik technologies pvt. Ltd.