Re: Trigger and LIKE SQL syntax

[Jay Pipes]

Try using:

select count(name) into old_name_count from store where name LIKE CONCAT('%', NEW.name, '%');

or

select count(name) into old_name_count from store where INSTR(name, NEW.name) > 0 ;

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com