Have a look at:
You can find there functions to use in SELECT and WHERE clauses, like
UPPER(), LOWER(), SUBSTRING(), etc. and
for string comparison functions (LIKE, REGEXP, MATCH AGAINST, ...).
On Thu, 2003-09-04 at 18:32, Darryl Hoar wrote:
> When I am doing a select or update statement, I was wondering if there were
> functions to compare strings. IE
> Select * from employee,emp2 where uppercase(employee.fname)
> that is to compare two fields from two tables and see if they match
> regardless of whether
> one is upper,lower,mixed case. Also see if table1.field1 is a partial match
> to another.
> JOHNATHAN would match Jon or Jonny.