mysql :: strict string compare

[voxecho]

is there anyway to get a strict string compare in a select statement?

e.g. select * From tblename where fieldname === 'Some Value';

it would then ignore a row with 'some value' as the field value

-Thanks

[oesxyl]

is there anyway to get a strict string compare in a select statement?

e.g. select * From tblename where fieldname === 'Some Value';

it would then ignore a row with 'some value' as the field value

-Thanks


select * from tblname where strcmp(fieldname,'Some Value') = 0


regards

[voxecho]

excellent, thank you

[oesxyl]

excellent, thank you
you are welcome, :)

best regards

[Fumigator]

The MySQL manual states that STRCMP is case insensitive, meaning STRCMP('Fumigator', 'fumigator') will return 0. Is this true? I can't test it atm.

[oesxyl]

The MySQL manual states that STRCMP is case insensitive, meaning STRCMP('Fumigator', 'fumigator') will return 0. Is this true? I can't test it atm.
I don't find any mention about that, so I tested and you are right, is case insensitive.

select strcmp('Fumigator', 'fumigator');

result is 0 same like for:


select strcmp('Fumigator', 'Fumigator');


try this:

select binary 'Fumigator' = 'fumigator';

return 0

select binary 'Fumigator' = 'Fumigator';

return 1

seems that comparison are case insensitive by default that's why we must use binary. :)

best regards