LIKE or = ?

[Stefan Schmiedl]

Alexander I. Barkov wrote:

AIB> I think that this qyery is what you want:

AIB> SELECT
AIB>         sum(category LIKE "pc_digital_camers") as count0,
AIB>         sum(category LIKE "pc_memory") as count1,
AIB>         ...........
AIB>         sum(caterogy LIKE "something_else") as count12
AIB> FROM
AIB>         items;

Hi,

why should you use LIKE when there are no wildcards in the string?
Case ignorance? Performance? Preparation for using wildcards later?

Regards,
S.
--
Stefan Schmiedl
Loreleystr. 5, 94315 Straubing, mailto: s@stripped
Tel.: [phone], Fax: [phone]