minte9
SoftwareDevelopment / MYSQL





Regexp 

 
SELECT 'a' REGEXP '^[a-d]'; // 1

Word boudaries 

 
SELECT 'abc def' REGEXP '[[:<:]]abc[[:>:]]' ; // 1

SELECT 'abcdef' REGEXP '[[:<:]]abc[[:>:]]' ; // 0






Questions and answers:
Clink on Option to Answer




1. How do you use regexp?

  • a) SELECT ... WHERE catg {{REGEXP}} 'java[a-z0-9]'
  • b) SELECT ... WHERE catg {{REGEX}} '/java[a-z0-9]/'


References: