Hey Ron
Sure can with the BINARY keyword
http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html
Bastien> From: [EMAIL PROTECTED]> To: php-db@lists.php.net> Date: Thu, 6 Mar
2008 22:45:09 -0500> Subject: [PHP-DB] Case sensitive query> > Is it poss
Is it possible to do a case sensitive query to mySQL? What would an
example syntax look like? Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
better to use the sql UPPER/LOWER and keep your variable values the same
Except that they should be escaping the variable to make it db-safe so
that will change it ... so if you're going to do that, might as well do
this:
$safe_stringinput = _escape_string(strtoupper($stringinput);
One
Check to see if you have the Binary option on the field. That would
make searches case sensitive. If it is a binary field, you need to
drop the binary option.
On Aug 24, 2005, at 4:53 PM, Chris Payne wrote:
Hi there everyone,
I have a little problem, I have a search where people can sea
better to use the sql UPPER/LOWER and keep your variable values the same
Bastien
From: <[EMAIL PROTECTED]>
To:
CC: <[EMAIL PROTECTED]>
Subject: Re: [PHP-DB] Case sensitive
Date: Wed, 24 Aug 2005 14:29:56 -0400
One trick is to force the case in your comparison:
$ucstringinput
One trick is to force the case in your comparison:
$ucstringinput = strtoupper($stringinput);
$qry = "select * from sometable where upper(address) like '%$ucstringinput%'"
Didn't think LIKE was case sensitive, but regardless... forcing upper or
lowercase in your comparison doesn't affect output
Perhaps its a collatioon issue? Are you using the same characterset for
both?
Bastien
From: Micah Stevens <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Case sensitive
Date: Wed, 24 Aug 2005 11:26:38 -0700
Not sure here, as according to my experience, and the MySQ
In fact, by issuing the following query:
SELECT "TEST" LIKE "test";
you can prove this to yourself, if it's case insensitive, it will return true
(1), otherwise false (0).
-Micah
On Wednesday 24 August 2005 1:53 pm, Chris Payne wrote:
> Hi there everyone,
>
>
>
> I have a little problem, I
Not sure here, as according to my experience, and the MySQL docs, SQL pattern
matching (as you would use with the 'LIKE' syntax) is case-insensitive. From
the docs:
"In MySQL, SQL patterns are case-insensitive by default. Some examples are
shown here. "
http://dev.mysql.com/doc/mysql/en/patte
Hi there everyone,
I have a little problem, I have a search where people can search the address
of a property BUT the search is case sensitive, I don’t WANT it to be. I’m
using MySQL and PHP and I generally use something like WHERE address LIKE
‘%$stringinput%’ which works with the numbers ONL
Rosen wrote:
Hi,
I have a simple table:
test (
id int unsigned NOT NULL auto_increment,
data varchar(30) default NULL,
PRIMARY KEY (id))
with two simple records:
id data
1 "a"
2 "A"
When I perform "select * from test where data='a' " - it return me both
rows.
http://dev.mysq
Hi,
I have a simple table:
test (
id int unsigned NOT NULL auto_increment,
data varchar(30) default NULL,
PRIMARY KEY (id))
with two simple records:
id data
1 "a"
2 "A"
When I perform "select * from test where data='a' " - it return me both
rows.
By default in MySQL comp
12 matches
Mail list logo
