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 ;

delimiter //

create or replace function search_street(vAddress varchar(100)) returns int
begin 
	declare vNoteID int default 0;
	declare vNoteName varchar(100);
	declare done int default 0;
	declare vCode int default 0;
	declare StreetCursor cursor for select nb_code, nb_name from note_bodys where note_bodys.nb_header = 6; 
	declare continue handler for sqlstate '02000' set done = 1;
	open StreetCursor;
	
	repeat
		fetch StreetCursor into vNoteID, vNoteName;
		if not done then
			select locate (replace(vNoteName,'.',''), vAddress) into vCode;
			if vCode = 1 then
				return vNoteId;
			end if;
		end if;
	until done end repeat;
	close StreetCursor;
	return vCode;
end;

//

delimiter ;