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
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
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.
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 MySQL docs
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
better to use the sql UPPER/LOWER and keep your variable values the same
Bastien
From: [EMAIL PROTECTED]
To: php-db@lists.php.net
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
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
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);
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 comparing
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.
I have the following example case:
1- More than 1000 record in my MySQL database.
2- I have to submit those record via HTTP GET or POST method.
3- I have to read the confirmation message that will be printed on the
remote page showing me that the vars have been inserted in the remote
database.
4-
Nabil wrote:
1-the problem is that the 30 second of execution time expired before i can
send even 200 records.
http://php.net/set_time_limit
Personally I'd call set_time_limit once for each iteration of the loop
with a sensible timeout like 30 seconds. Alternatively you can call it
once at the
I want to test a value that was typed into a form, but I don't want the case
to be a problem, how can I get around this??
This is what I have now:
function calculate_tax($OrderedByState,$ShipState)
{
global $totalPrice;
//tax calculation
$taxRate = 0.05;
if ($OrderedByState==MA
Use strtolower() on all entries from the form, so you can compare them (in lowercase)
without worry about whether the user entered MA, ma, Ma, or mA.
Martin
James Kupernik [EMAIL PROTECTED] 06/11/02 10:15AM
I want to test a value that was typed into a form, but I don't want the case
to be a
on 6/11/02 10:15 AM, James Kupernik at [EMAIL PROTECTED] appended the
following bits to my mbox:
I want to test a value that was typed into a form, but I don't want the case
to be a problem, how can I get around this??
This isn't a database related question, so it should probably be posted to
Hi:
Anyone offer recommendations for a CASE/E-R
modeling/Data dictionary tool that can be used with
MySQL?
Thanks
Luis
__
Do You Yahoo!?
Get email alerts NEW webcam video instant messaging with Yahoo! Messenger.
http://im.yahoo.com
--
PHP
i use ...
SELECT *, UPPER(name) AS testfield FROM testtable ORDER BY testfield
hope it helps.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL
im trying to do a case insensitive search in pgsql with a "WHERE blah
LIKE '%blah%'"
the problem is that currently if something contains Blah not just blah
it wont return that. suggestion? i know i can suck out every row and
then eregi them but that is majorly slow and inefficent . . .
Cameron
You could use the UPPER function. Fortunately you're using PostgreSQL,
which conforms with much of the ANSI standard. UPPER and LOWER are
implementations of the fold functions required by ANSI SQL. This would be
the most standard way to solve your problem (with the notable exception of
support
19 matches
Mail list logo