Is it only pulling up the first record in a script that you are writing
(like in a PHP script) or does it also exhibit this behavior if you enter
your query from the mysql command line interface?
If it is the former, I would imagine there is a problem with your script.
HTH
Sam Masiello
Software Quality Assurance Engineer
Synacor
(716) 853-1362 x289
[EMAIL PROTECTED]
-----Original Message-----
From: winnecon [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 3:24 PM
To: [EMAIL PROTECTED]
Subject: Wild-card search problem
--
I have searched through all of the MySQL documentation I can get my
hands on, but still have no explanation for the following "wild-card
search" problem.
I enter the following query:
SELECT name,keywords,description from database_t where 1 and name
like "p%" LIMIT 0, 30;
-- or --
SELECT name,keywords,description from database_t where name like "p%"
LIMIT 0, 30;
This should return all records where name starts with the letter P.
It only returns the first record (since the first record starts with P).
When I use any other letter or number no records are returned.
The query is being performed on a 7000+ record database and should
pull up several hundred records starting with the letter P.
I am running MySQL 3.23.40 on BSD UNIX (MAC OSX), but had the
identical problem with 3.23.28, 3.23.36 and 3.23.38.
Thanks in advance,
Brett
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php