MySQL Forums
Forum List  »  UDF

arrays to/in Funktions
Posted by: Roman Pretory
Date: June 26, 2012 05:03AM


How could I get the follow array into a FUNCTION or PROCEDURE....

value = ('<555>','<esfsf>','<ttt>')

Count how many vars are in the array as count1

remove the "<,>"

SET count2 = (SELECT COUNT(*) FROM ttt where table in "value without <,>");

I need to return 0 IF count1-count2 >0 or 1 if not,
but this part is easy

is there a explode,while,for to do this?? Where could I find the syntax or examples how are arrays handed in Function


Options: ReplyQuote

Written By
arrays to/in Funktions
June 26, 2012 05:03AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.