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.
精彩评论