Hi,
Have a look at:
http://www.mysql.com/doc/en/String_functions.html
You can find there functions to use in SELECT and WHERE clauses, like
UPPER(), LOWER(), SUBSTRING(), etc. and
http://www.mysql.com/doc/en/String_comparison_functions.html
for string comparison functions (LIKE, REGEXP, MATCH AGAINST, ...).
On Thu, 2003-09-04 at 18:32, Darryl Hoar wrote:
> greetings,
> 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)
> matches(emp2.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.
>
> So,
> JOHNATHAN would match Jon or Jonny.
>
> thanks,
> Darryl
--
Diana Soares
