MySQL Forums
Forum List  »  UDF

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

Hi

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

Thanks
Roman

Options: ReplyQuote


Subject
Views
Written By
Posted
arrays to/in Funktions
2874
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.