fork(17) download
copy 
  1. PRAGMA case_sensitive_like=OFF;
  2. CREATE TABLE test
  3. (
  4.   id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  5.   title TEXT
  6. );
  7.  
  8. INSERT INTO `test` (`title`) VALUES ('мир');
  9. INSERT INTO `test` (`title`) VALUES ('foo');
  10. INSERT INTO `test` (`title`) VALUES ('ёж');
  11. INSERT INTO `test` (`title`) VALUES ('Мир');
  12. INSERT INTO `test` (`title`) VALUES ('Ёж');
  13.  
  14. SELECT * FROM `test` WHERE title LIKE  '%Ми%';
Success #stdin #stdout 0s 3404KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
4|Мир
https://ideone.com/wWJkvL
language:
SQLite (sqlite 3.27.2)
created:
10 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!