SELECT title, title REGEXP 'apple' as is_fruit FROM mytable;
TO:
SELECT title, title REGEXP 'apple' or orange...or grapes...as is_fruit...
Basically, how do I do an "OR" for开发者_开发百科 REGEXP?
SELECT title, title REGEXP '(apple|orange|...)' as is_fruit FROM mytable;
精彩评论