Skip to content

Instantly share code, notes, and snippets.

@sanikolaev

sanikolaev/gist:a8b84e6c1d6e784a746ea7c16b402db2

Created April 30, 2020 07:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sanikolaev/a8b84e6c1d6e784a746ea7c16b402db2 to your computer and use it in GitHub Desktop.
Save sanikolaev/a8b84e6c1d6e784a746ea7c16b402db2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
➜ ~ docker run --name manticore -p9306:9306 -p9308:9308 --rm -d manticoresearch/manticore && \
docker exec -it manticore mysql && \
docker stop manticore
MySQL [(none)]> create table t2(f text);
MySQL [(none)]> insert into t2 values(0,'6406 Pz.Kpfw.VI Ausf.E Tiger I Late Production'),(0,'6800 Танк Wittmann\'sLast Tiger');
MySQL [(none)]> select * from t2;
+---------------------+------------------------------------------------+
| id | f |
+---------------------+------------------------------------------------+
| 1657853872082780192 | 6406 Pz.Kpfw.VI Ausf.E Tiger I Late Production |
| 1657853872082780193 | 6800 Танк Wittmann'sLast Tiger |
+---------------------+------------------------------------------------+
MySQL [(none)]> select * from t2 where match('Tiger');
+---------------------+------------------------------------------------+
| id | f |
+---------------------+------------------------------------------------+
| 1657853872082780192 | 6406 Pz.Kpfw.VI Ausf.E Tiger I Late Production |
| 1657853872082780193 | 6800 Танк Wittmann'sLast Tiger |
+---------------------+------------------------------------------------+
MySQL [(none)]> select * from t2 where match('tiger');
+---------------------+------------------------------------------------+
| id | f |
+---------------------+------------------------------------------------+
| 1657853872082780192 | 6406 Pz.Kpfw.VI Ausf.E Tiger I Late Production |
| 1657853872082780193 | 6800 Танк Wittmann'sLast Tiger |
+---------------------+------------------------------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment