Examples of using wildcards in LIKE select * from test; x -------- abc cba dba cab e_ab (5 row(s) affected) select * from test where x like '[ac]%' x -------- abc cba cab (3 row(s) affected) select * from test where x like '[^ac]%' x -------- dba e_ab (2 row(s) affected) select * from test … Continue reading Examples of using wildcards in LIKE
Tag: expression
Regular expression
One can use the regular expressions to match in vi, grep, sed and awk. [a-d] - Match one character with in a-d i.e. a, b, c, d [^a-d] - Match one character not in the range a-d \<test\> - Match whole word test test\> - Match words that ends with test \<test\> \1ing - Match … Continue reading Regular expression
alexlima.com 