You use the LIKE operator to retrieve rows that match a string pattern. The Mask for a LIKE phrase can contain special symbols called “wildcards”. Masks aren’t …
source
09 MySQL Tutorial for Beginners: LIKE + REGEXP Operators, Regular Expressions
You use the LIKE operator to retrieve rows that match a string pattern. The Mask for a LIKE phrase can contain special symbols called “wildcards”. Masks aren’t …
source
2 responses to “09 MySQL Tutorial for Beginners: LIKE + REGEXP Operators, Regular Expressions”
$qry="select classid from examtab where classid like '".$roll."%' and classid like '%".$branch."%'";
how can I write the above query in crct way?
where classid will b of the form:1322CSE….here 13 is roll n branch is CSE…
great thank you very much. And I look such operators like * . and other with examples if somebody such great lessons with * and . please attach the link)