Mysql选择查询运行的所有

Question

I have the following query:

$query = $this->db->query("SELECT * FROM so.KI WHERE ICCID IN ('$nabi') ") or die(mysql_error());

But I get the following error:

A Database Error Occurred

Error Number:

SELECT * FROM so.KI WHERE ICCID in 8993017100107912997,8993017100107913011,8993017100107913029,8993017100107913037,8993017100107913045

They so database is Oracle and the KI table has got 2700000 records.

any help is highly appreciated! I wonder why such error is showed up!

Answer 1

here 8993017100107912997,8993017100107913011,8993017100107913029,8993017100107913037,8993017100107913045 is diffrent ids so as per you had defin

"SELECT * FROM so.KI WHERE ICCID IN ('$nabi') " its contain all string in condition.

please try below. and also check DATAbase connection also.

"SELECT * FROM so.KI WHERE ICCID IN ($nabi) "