mysql 绝对单词匹配

不是like单词 而是完全匹配一个单词

SELECT
	a.term_id cat_1,
	b.parent cat_2,
	a. NAME
FROM
	mot_terms a
LEFT JOIN mot_term_taxonomy b ON a.term_id = b.term_id
WHERE
	`name` REGEXP '[[:<:]]cell[[:>:]]'
OR `name` REGEXP '[[:<:]]phone[[:>:]]'

mybatis 传入一个字符串的处理

	<select id="get_category_of_avaiable" resultType="Search_Record">	
			SELECT c.* ,d.name cat1_name from (
			SELECT a.term_id cat2_id,b.parent cat1_id ,a.name cat2_name   from mot_terms a LEFT JOIN mot_term_taxonomy  b on a.term_id=b.term_id   
			where b.taxonomy='category' and b.parent>=1
			<if test="length == 1">
				<![CDATA[ and a.name REGEXP '[[:<:]]${names}[[:>:]]']]>	
			</if> 
			<if test="length > 1">
			and
				<foreach collection="names" item="word" open="(" separator=" or " close=")">
					<![CDATA[ a.name REGEXP '[[:<:]]${word}[[:>:]]']]>	
				</foreach>
			</if>
			) c LEFT JOIN 
			mot_terms d on c.cat1_id =d.term_id	 
	</select>