SQL & MySQL: Using local variables in complex queries

complex_like_expression.sql

set @s1 = '%123aaabbbcccdddeeefffggg%';

select * from `items` where 
(
       `title` LIKE @s1 or `apn` LIKE @s1 or `slug` LIKE @s1 
	or exists (select * from `sellers` where `items`.`seller_id` = `sellers`.`id` 
		   and (`title` LIKE @s1 or `slug` LIKE @s1 or `address` LIKE @s1)
	) 
	or exists (select * from `item_geos` 
		   where `items`.`id` = `item_geos`.`item_id` 
		   and (`state` LIKE @s1 or `acreage` LIKE @s1 or `county` LIKE @s1 or `city` LIKE @s1 
				  or `address` LIKE @s1 or `zip` LIKE @s1
		   )
	)
);