如何使用“喜欢查询”用于从mysql数据库中搜索任何数据 [英] how to use "like query" for searching any data from mysql database
问题描述
嗨..
使用类似查询从任何表中搜索任何数据都有问题..
任何人都可以帮助我..
谢谢..
我的代码看起来像..
DELIMITER $ $
USE`code` $$
DROP PROCEDURE IF EXISTS`Searchcodes` $$
CREATE DEFINER =`root` @`localhost` PROCEDURE`Searchcodes`(searchtext VARCHAR(50))
BEGIN
SELECT * FROM icd9diagnosis WHERE ICD9DiagnosisCodes LIKE'%searchtext%';
END $$
DELIMITER;
CALL Searchcodes('0010');
USE`code`
DROP PROCEDURE如果存在`Searchcodes`
CREATE DEFINER =`root` @`localhost` PROCEDURE`Searchcodes`(searchtext VARCHAR(50))
BEGIN
SELE CT * FROM icd9diagnosis WHERE ICD9DiagnosisCodes LIKE'%searchtext%';
END
hi..
there is a problem to search any data from any table using like query ..
anybody is there for helping me..
thank you ..
my code is looks like as..
DELIMITER $$
USE `codes`$$
DROP PROCEDURE IF EXISTS `Searchcodes`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `Searchcodes`(searchtext VARCHAR(50))
BEGIN
SELECT * FROM icd9diagnosis WHERE ICD9DiagnosisCodes LIKE '%searchtext%' ;
END$$
DELIMITER ;
CALL Searchcodes('0010');
USE `codes`
DROP PROCEDURE IF EXISTS `Searchcodes`
CREATE DEFINER=`root`@`localhost` PROCEDURE `Searchcodes`(searchtext VARCHAR(50))
BEGIN
SELECT * FROM icd9diagnosis WHERE ICD9DiagnosisCodes LIKE '%searchtext%' ;
END
这篇关于如何使用“喜欢查询”用于从mysql数据库中搜索任何数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!