0
SELECT * FROM `table` WHERE `column`='System'

and this select 'SYSTEM' too. I want to select only and accurately `column`='System' without 'SYSTEM'.

I'm try this:

SELECT * FROM `table` WHERE `column` REGEXP [[:<:]]'System'[[:>:]]

but again I have 'SYSTEM' too.

Barmar
  • 741,623
  • 53
  • 500
  • 612
Svetoslav Ivanov
  • 15
  • 1
  • 5
  • `SELECT REPLACE(column, 'SYSTEM', '')` to remove the word `SYSTEM` from the column. – Barmar Nov 10 '20 at 18:27
  • 2
    You want a case sensitive comparison. `WHERE column LIKE 'System' COLLATE latin1_general_cs`. Look here: https://stackoverflow.com/questions/5629111/how-can-i-make-sql-case-sensitive-string-comparison-on-mysql – Thorsten Kettner Nov 10 '20 at 18:30
  • I just want SELECT * FROM `table` WHERE `column`='System' Start with capital letter and other small letters – Svetoslav Ivanov Nov 10 '20 at 18:34
  • This works for me: SELECT * FROM `table` WHERE BINARY `column` = 'value'. Many thanks! – Svetoslav Ivanov Nov 10 '20 at 18:39

0 Answers0