开发者

mysql regular expression matching query

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜