AFAIK, repeated LIKEs.
On Tue, Mar 24, 2009 at 6:24 AM, Yariv Omer wrote:
> Hi
>
> when I am using a query for several field's values I am using the following
> query:
> Select field from table where in ('11', '22')
>
> I need to do a LIKE search (not exact match but like match)
>
> How can I do
Hi
when I am using a query for several field's values I am using the
following query:
Select field from table where in ('11', '22')
I need to do a LIKE search (not exact match but like match)
How can I do it
Thanks, Yariv
--
MySQL General Mailing List
For list archives: http://lists.mysql
On 8/24/06, João Cândido de Souza Neto <[EMAIL PROTECTED]> wrote:
You ought to choice one of these ways:
while ($row=mysql_fetch_row($result)){
echo "$row[1] \n";
}
OR
$row = mysql_fetch_row($result);
do {
echo "$row[1] \n";
} while ($row=mysql_fetch_row($result));
"Marcelo Fabi
You ought to choice one of these ways:
while ($row=mysql_fetch_row($result)){
echo "$row[1] \n";
}
OR
$row = mysql_fetch_row($result);
do {
echo "$row[1] \n";
} while ($row=mysql_fetch_row($result));
"Marcelo Fabiani" <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED
-Original Message-
From: Marcelo Fabiani [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 24, 2006 1:38 PM
To: mysql@lists.mysql.com
Subject: using like
Hi to all the group, I have a problem with a query using mysql
4.01+mysql+php
This is the form i use to get the data for the query:
http
Hi to all the group, I have a problem with a query using mysql
4.01+mysql+php
This is the form i use to get the data for the query:
http://www.ibtec.info/resbu.php";>
Ingrese palabra a buscar
and here is the php i use
\n";
$row = mysql_fetch_row($result);
while ($row=m
s
> it does not offer the granularity needed.
>
>
>
> Please see below:
>
>
>
> Optimizer Penalty for using LIKE + ORDER BY + LIMIT
>
>
>
> a) Using Full Text Search
>
> mysql> SELECT a.dvd_id FROM dvd a, dvd_search s WHERE a.dvd_id = s.dv
:
Optimizer Penalty for using LIKE + ORDER BY + LIMIT
a) Using Full Text Search
mysql> SELECT a.dvd_id FROM dvd a, dvd_search s WHERE a.dvd_id = s.dvd_id
and match (s.title) against ('breakfast' in boolean mode) ORDER BY
a.title_sort, a.director LIMIT 0,50;
10 rows in set (0.00 sec)
Hello,
I have a problem. I have two tables one with the
long sentences(TABLE 1) and one with the words in that
sentences(TABLE 2).
what i need to do is query the TABLE 2 by giving a
part of the word ---WILD CARD MATCHING-and get the
complete words which contains this part.
Then Use thi
On Saturday, March 29, 2003, at 07:41 AM, Trevor Smith wrote:
2. your syntax just seems wrong. This should be:
SELECT * FROM MyTable WHERE NeedleColumn LIKE '%needle%';
to search for the string 'needle' anywhere in NeedleColumn, if that's
what you were looking for.
I'm jumping in mid-stream so
On Sat, 29 Mar 2003 05:43:53 -0500, Jeff Moore wrote:
>However, this query does not work correctly If you generalize is to
>include a database column:
>
>SELECT * FROM MyTable WHERE 'haystack needle haystack' LIKE CONCAT('%',
>NeedleColumn, '%')
Two things:
1. you don't seem to need the CONCAT
I am having the same problem.
This Query:
SELECT 'haystack needle haystack' LIKE concat('%', 'needle', '%')
returns 1
However, this query does not work correctly If you generalize is to
include a database column:
SELECT * FROM MyTable WHERE 'haystack needle haystack' LIKE CONCAT('%',
NeedleC
it this specific need.
/Jakob
> -Original Message-
> From: Jeff Shapiro [mailto:[EMAIL PROTECTED]
> Sent: Sunday, March 23, 2003 7:46 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Using LIKE to search for occurence of a column value in a
> string
>
>
> The reason
The reason that what you are doing isn't working is because you are
trying to find a really long string in a short string. You need to
reverse your string searching.
Try:
SELECT URL, Name
FROM websites
WHERE LOCATE(URL,
'http://www.microsoft.com/kb/knowledgeb.asp?id=3&strse=12') > 0;
Here's s
I thought you only could use the likesyntax like this;
SELECT column from table where column like '%data%';
i have a hard time seeing what goodit would be calling a column
http:// =)
check;
http://www.mysql.com/doc/en/Pattern_matching.html
regards
lasse
On Sun, 23 Mar 2003, Ville Mattila wr
> I tried to use LIKE:
> SELECT URL, Name
> FROM websites
> WHERE 'http://www.microsoft.com/kb/knowledgeb.asp?id=3&strse=12'
> LIKE (URL + '%');
>
> But this doesn't return any results. I would like the following as output:
> 'http://www.microsoft.com/kb/'Microsoft Knowledgebase
Hi!
How a
I wan't to search for all rows that match a value.
I have these rows:
URL Name
'http://www.microsoft.com/kb/' Microsoft Knowledgebase
'http://www.microsoft.com/search/' Microsoft Search
Now I wan't to find all occurences where any of above URL col
ECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: 28 March 2002 19:16
Subject: Re: SQL query question - using LIKE
> DL -
>
> Points well taken -
> I am using php and doing simple validation
> EX - if ($fname !="") {
> add fname string to search variabl
rch 28, 2002 11:52 AM
Subject: Re: SQL query question - using LIKE
>Mark, Peter,
>
>The query below assumes that the user will search of FirstName and none
>or more of the other fields - which was not how the question reads (to
>me).
>
>To answer the question it would be us
eter
>
> ---
> Excellence in internet and open source software
> ---
> Sunmaia
> www.sunmaia.net
> [EMAIL PROTECTED]
> tel. 0121-242-1473
> --
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
---
> -Original Message-
> From: Mark Stringham [mailto:[EMAIL PROTECTED]]
> Se
I have a simple search form that allows the user to search a contact db
based on criteria that they choose.
Search by -
first name - text box
last name - text box
region - drop down
loan officer - drop down
I want the user to be able to receive results if they choose all possible
criteria or jus
Hi!
On Sep 21, Jordan Elver wrote:
> Hi,
> Thanks for the advice. Looked on mysql.com for advice on REGEXP. Seems
> promising but I can't seem to find the right regexp (I hate them :-()
>
> I might just have to screen the words before I search like james suggested,
> does anyone know where I c
> Good Luck.
>
> -Original Message-
> From: Jordan Elver [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 21, 2001 9:03 AM
> To: MySQL Mailing List; PHP DB Mailing List
> Subject: [PHP-DB] Searching MySQL using LIKE
>
> Hi,
> I'm cross posting this because i
24 matches
Mail list logo
