delimiter //

create or replace function search_street(vStreet varchar(100)) returns int(11)
begin
	declare vNoteID int;
	declare vNoteName varchar(50);
	declare done int default 0;
	declare StreetCursor for select nb_code, nb_name from note_bodys where nb_header = 6;
	declare continue handler for sqlstate '0200' set done = 1;
	open StreetCursor;
	
	repeat
		fetch StreetCursor into vNoteID, vNoteName;
		if not done then 
			//Вот  вариантик - только не пойму как забрать результат = 1
			select locate (vNoteName, vStreet)	
		
		end if;
	until done end repeat;
	close StreetCursor; 
	return vNoteID;
end;

//

delimiter ;