56,678
社区成员
发帖
与我相关
我的任务
分享
mysql> select * from books;
+----+-------+
| id | name |
+----+-------+
| 1 | OK |
| 2 | Hello |
| 3 | bbb |
+----+-------+
3 rows in set (0.03 sec)
mysql> SELECT id, name FROM books WHERE instr( name, 'OK' ) ;
+----+------+
| id | name |
+----+------+
| 1 | OK |
+----+------+
1 row in set (0.44 sec)
mysql> SELECT id, name FROM books WHERE instr( 'OK', name ) ;
+----+------+
| id | name |
+----+------+
| 1 | OK |
+----+------+
1 row in set (0.00 sec)
mysql>
CREATE TABLE IF NOT EXISTS books (
id int(11) unsigned NOT NULL AUTO_INCREMENT,
name varchar(20) COLLATE utf8_unicode_ci NOT NULL
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
INSERT INTO books (id, name) VALUES (1, 'OK'), (2, 'Hello'), (3, 'bbb');
SELECT id, name FROM books WHERE instr( name, 'OK' ) ;
SELECT id, name FROM books WHERE instr( 'OK', name ) ;
SELECT id, name FROM books where instr(name,'aaaaaITbbbbb')