Re: CAN SOMEONE HELP ME? - Michael Ellis - com.mysql.lists.win32

16 messages in com.mysql.lists.win32Re: CAN SOMEONE HELP ME?

From	Sent On	Attachments
Patrick O'Shea	27 Feb 2001 12:27
Jerry Lake	27 Feb 2001 13:01
Patrick O'Shea	27 Feb 2001 13:32
Jerry Lake	27 Feb 2001 14:21
Stephen Woodbridge	27 Feb 2001 14:29
Stefan Schmiedl	27 Feb 2001 15:16
Nat Bell	27 Feb 2001 15:31
Nat Bell	27 Feb 2001 15:32
Christopher R. Jones	27 Feb 2001 15:48
Patrick O'Shea	27 Feb 2001 22:20
Pete French	28 Feb 2001 03:41
Stefan Schmiedl	28 Feb 2001 07:14
Joris Lambrecht	28 Feb 2001 07:59
Stefan Schmiedl	28 Feb 2001 11:54
Jerry Lake	28 Feb 2001 12:53
Michael Ellis	02 Mar 2001 15:44

Subject:	Re: CAN SOMEONE HELP ME?
From:	Michael Ellis (mel...@frogwing.com)
Date:	03/02/2001 03:44:36 PM
List:	com.mysql.lists.win32

Patrick,

Use regular expressions.

First, translate the keyword to an alternation of upper and lower case. e.g use a query like

SELECT whatever FROM some_table WHERE some_field REGEXP 'R|rE|eC|cO|oR|rD|d'

to find all rows that match 'record' case-insensitive.

Cheers, Mike

Hi, I'm currently working on a searchable dynamic content site and have a question about queries in mysql. when making a query using the LIKE operator, is there a way to ignore case? I have a problem with when I search the database using a LIKE query it is case sensitive(i.e. the search keyword is record, but the in the database it is Record), yet it will not return due to the case. Can anyone help me? Patrick O'Shea