IN Clause in Dynamic Query

[tarunsanju15]

Hi,

I am writing a dynamic query in which i have to select a records depend upon the no. of values entered by user like:
select * from _table where _tableColumn IN (values entered by user)

the values entered come in this format: 456,465,123
bt if i pass this value in string format through a bind variable. The query is not working it is taking whole value as whole..

Please help me out..
I am writing this query in MySql

[write2ashokkumar]

Hi,

I am writing a dynamic query in which i have to select a records depend upon the no. of values entered by user like:
select * from _table where _tableColumn IN (values entered by user)

the values entered come in this format: 456,465,123
bt if i pass this value in string format through a bind variable. The query is not working it is taking whole value as whole..

Please help me out..
I am writing this query in MySql

hi...

for do this, u have to use the dynamic sql.
For example:

user input value is 456,465,123....

first build the query lie this

set @vquery = CONCAT("select * from test_table where table_col in(","456,465,1 23",")");

prepare stmt from @vquery;
execute stmt;


Regards,
S.Ashokkumar

[ScarletPimpernal]

Hi,

Try this

SET @vValue := '456,465,123';

SET @vquery = CONCAT('select * from test_table where table_col in (', @vValue,');


PREPARE stmt from @vquery;
EXECUTE stmt;


Thanks,
Pimp

Hi,

I am writing a dynamic query in which i have to select a records depend upon the no. of values entered by user like:
select * from _table where _tableColumn IN (values entered by user)

the values entered come in this format: 456,465,123
bt if i pass this value in string format through a bind variable. The query is not working it is taking whole value as whole..

Please help me out..
I am writing this query in MySql