Integer Array in Mysql Stored Procedure

Question

How do i use integer values array in Mysql Stored procedure ?

Raj · Accepted Answer · 2013-10-02 05:50:06Z

3

This helps for me to do IN condition Hope this will help you..

CREATE  PROCEDURE `test`(IN Array_String VARCHAR(100))
BEGIN
    SELECT * FROM Table_Name
    WHERE FIND_IN_SET(field_name_to_search, Array_String);

END//;

Calling:

call test('3,2,1');

answered Oct 2, 2013 at 5:50

Raj

7178 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:34:38Z

2

if you want to pass to the stored procedure an array look at

How can I pass an "array" of values to my stored procedure?

and

http://www.coderanch.com/t/505422/Oracle-OAS/pass-Integer-Array-Stored-Procedure

edited May 23, 2017 at 12:34

CommunityBot

11 silver badge

answered Nov 11, 2010 at 9:39

Haim Evgi

126k46 gold badges222 silver badges226 bronze badges

Collectives™ on Stack Overflow

Integer Array in Mysql Stored Procedure

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related