Tag Info

New answers tagged

0

Join table1 and table2. Something like: SELECT t2.searchItem FROM table2 as t2 JOIN table1 as t1 ON t1.tabid = t2.table2_id WHERE t2.searchItem LIKE CONCAT(sText , '%') AND IFNULL(tabId , '') != '' and t1.table1_id= myId LIMIT 15 ; Bottom line, you don't need the @myCid variable


2

Either way, that's totally possible, given that all your parameters are of the same data type. EXECUTE ... USING happily takes an array, which is treated as a single argument. Access elements with array subscripts. create or replace function test_function(_filter1 text = null , _filter2 text = null ...



Top 50 recent answers are included