select * from a where left(filed1,4)='".substr(string,0,4)."'"
或
select * from a where filed1 like '".substr(string,0,4)."%'"
或
select * from a where filed1 like '".substr(string,0,4)."%'"
解决方案 »
- ████莪在000webhost申请了一个免费的MYSQL空间、但是怎么也连不上去 ████
- WINDOWS 编译MYSQL
- 求教:如何实现执行字符串信息???
- 实在不理解了
- 经常性的"Lost connection to MYSQL server during query at ..."
- 请教:为什么我的Welcome to phpMyAdmin 2.5.1 - Login不能登陆?
- 我是MYSQL新手,请教各位大虾,在MYSQL中如何创建字符集为“UTF-8”或为“ISO8859-1”的数据库,能否给出SQL具体语句,万分感谢,我的VER
- 怎么写这样的SQL语句!在线等!
- 请教如何解决用DevC++工具使用MySQL C API连接MySQL的出错问题。
- 在mysql中怎么样更有效的实现多个数据库的数据统计?急!
- 在WIN和PWS下安装MYSQL4,不能正常运行。密码是什么?
- 王**的猜想:一个大大的服务器上只有一个不大的网站,能把网站全部调入内存码?
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 3.23.43-nt-logType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> SELECT Host,User FROM mysql.user;
+-----------+-------+
| Host | User |
+-----------+-------+
| % | root |
| localhost | |
| localhost | Guest |
| localhost | card |
| localhost | root |
| pc02 | root |
+-----------+-------+
6 rows in set (0.00 sec)
->查看mysql.user所有数据mysql> SELECT Host,User FROM mysql.user WHERE User Like 'root';
+-----------+------+
| Host | User |
+-----------+------+
| % | root |
| localhost | root |
| pc02 | root |
+-----------+------+
3 rows in set (0.01 sec)
->等同于SELECT Host,User FROM mysql.user WHERE User = 'root';mysql> SELECT Host,User FROM mysql.user WHERE User Like 'r%';
+-----------+------+
| Host | User |
+-----------+------+
| % | root |
| localhost | root |
| pc02 | root |
+-----------+------+
3 rows in set (0.00 sec)
->查看所有User第一个字符为 'r' 的mysql> SELECT Host,User FROM mysql.user WHERE Host Like '\%';
+------+------+
| Host | User |
+------+------+
| % | root |
+------+------+
1 row in set (0.00 sec)
->查看Host 为 '%'的,
\ 表转义mysql> SELECT Host,User,SubString(User,1,1) FROM mysql.user WHERE SubString(User,1,1)='r';
+-----------+------+---------------------+
| Host | User | SubString(User,1,1) |
+-----------+------+---------------------+
| % | root | r |
| localhost | root | r |
| pc02 | root | r |
+-----------+------+---------------------+
3 rows in set (0.00 sec)
->查看所有User第一个字符为 'r' 的
等同于SELECT Host,User FROM mysql.user WHERE User Like 'r%';
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 3.23.43-nt-logType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql>
mysql>
mysql>
mysql> SELECT Host,User FROM mysql.user;
+-----------+-------+
| Host | User |
+-----------+-------+
| % | root |
| localhost | |
| localhost | Guest |
| localhost | card |
| localhost | root |
| pc02 | root |
+-----------+-------+
6 rows in set (0.00 sec)
->查看mysql.user所有记录mysql> SELECT Host,User FROM mysql.user WHERE User Like 'root';
+-----------+------+
| Host | User |
+-----------+------+
| % | root |
| localhost | root |
| pc02 | root |
+-----------+------+
3 rows in set (0.01 sec)
->等同于SELECT Host,User FROM mysql.user WHERE User = 'root';mysql> SELECT Host,User FROM mysql.user WHERE User Like 'r%';
+-----------+------+
| Host | User |
+-----------+------+
| % | root |
| localhost | root |
| pc02 | root |
+-----------+------+
3 rows in set (0.00 sec)
->查看User的第一个字符为 'r'的记录mysql> SELECT Host,User FROM mysql.user WHERE Host Like '\%';
+------+------+
| Host | User |
+------+------+
| % | root |
+------+------+
1 row in set (0.00 sec)
->查看Host为 '%' 的记录
\ 为转义符mysql> SELECT Host,User,SubString(User,1,1) FROM mysql.user WHERE SubString(Usr,1,1)='r';
+-----------+------+---------------------+
| Host | User | SubString(User,1,1) |
+-----------+------+---------------------+
| % | root | r |
| localhost | root | r |
| pc02 | root | r |
+-----------+------+---------------------+
3 rows in set (0.00 sec)
->查看User的第一个字符为 'r'的记录
等同于SELECT Host,User FROM mysql.user WHERE User Like 'r%';