List:General Discussion« Previous MessageNext Message »
From:Diana Soares Date:September 4 2003 5:41pm
Subject:Re: MySQL syntax question
View as plain text  

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:
> 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

MySQL syntax questionDarryl Hoar4 Sep
  • Re: MySQL syntax questionDiana Soares4 Sep