开发者

mysql regular expression matching query

开发者 https://www.devze.com 2022-12-16 13:43 出处:网络
Is this both query are similar? or which query is best to use. SELECT name FROM employees WHERE skill_sets R开发者_如何学编程EGEXP \'[[:<:]]php[[:>:]]\'

Is this both query are similar? or which query is best to use.

SELECT name FROM employees WHERE skill_sets R开发者_如何学编程EGEXP '[[:<:]]php[[:>:]]'

SELECT name FROM employees WHERE skill_sets LIKE '%php%'


see a article :

http://thingsilearn.wordpress.com/2008/02/28/mysql-query-speed-regexp-vs-like/

If you just need fast, ‘any character’ pattern matching though, LIKE is your friend.

0

精彩评论

暂无评论...
验证码 换一张
取 消