Hi all,
I have to perform a mysql query in a table with millions of records.
I've full-text indexed my search field and I'm searching with MATCH AGAINST.
But there is a problem. In this field there are company names that
contain dots, for istance I've "PO.SE. srl" and I want to find it if
the u
I have a table like this: tb(ke varchar(10),kc varchar(10),...) where ke contains
ascii string while kc contains dbcs string in UTF8. The
character_set_server(system,database,client,connection) are all utf8. I have no
problem to query the table using "like 'xx%' " against column ke with xx as as
om Johnson [mailto:[EMAIL PROTECTED]
> Sent: 26 June 2003 14:23
> To: [EMAIL PROTECTED]
> Subject: Need your help in a search query
>
>
> Hi MySQL Experts,
>
> I am pretty new at this and need your help in figuring out if it is
possible
> to create a query to search for words i
TECTED]
> Sent: Thursday, June 26, 2003 7:23 AM
> To: [EMAIL PROTECTED]
> Subject: Need your help in a search query
>
>
> Hi MySQL Experts,
>
> I am pretty new at this and need your help in figuring out if
> it is possible
> to create a query to search for words in
You could try
SOUNDEX(str)
http://www.mysql.com/doc/en/String_functions.html
which might do what you are looking for
HTH
Peter
-Original Message-
From: Tom Johnson [mailto:[EMAIL PROTECTED]
Sent: 26 June 2003 14:23
To: [EMAIL PROTECTED]
Subject: Need your help in a search query
Hi MySQL Experts,
I am pretty new at this and need your help in figuring out if it is possible
to create a query to search for words in a given field. What I am trying to
do is allow a user to enter words to search for a given title in the
database. For example, a person is looking up the title
toby,
Tuesday, November 26, 2002, 10:55:38 AM, you wrote:
tz> plz tell me how can i run the qoute() function on $srch
tz> i tried to look the function up in mysql doccumentation online but no luck
tz> .
Here is described how QUOTE() function works:
http://www.mysql.com/doc/en/String_fu
Subject: Re: search query crashing mysql . :S
Date: Mon, 25 Nov 2002 09:17:43 -0600
You did not run the quote() funcion on $arch.
If $arch contains any special characters, it will break your query.
toby z wrote:
hay guyz
im havin a weired problem
i ve this search query
$srch_qry = "
You did not run the quote() funcion on $arch.
If $arch contains any special characters, it will break your query.
toby z wrote:
hay guyz
im havin a weired problem
i ve this search query
$srch_qry = " select ctnt_inf.* from ctnt_inf ".
" where (match (firstName ) aga
hay guyz
im havin a weired problem
i ve this search query
$srch_qry = " select ctnt_inf.* from ctnt_inf ".
" where (match (firstName ) against (\"".$srch."\") ".
" or match (lastName ) against (\"".$srch."\") ".
RGE.html
Just wondering: Why don't you use a single table, since they all
have the same structure ?
Regards
>
>> From: Joseph Bueno <[EMAIL PROTECTED]>
>> To: Pascale Lunal <[EMAIL PROTECTED]>
>> CC: [EMAIL PROTECTED]
>> Subject: Re: PHP search que
>From: Joseph Bueno <[EMAIL PROTECTED]>
>To: Pascale Lunal <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: PHP search query into all tables of a MySQL db
>Date: Thu, 26 Sep 2002 12:04:53 +0200
>
>Pascale Lunal wrote:
>>Oops: sorry if this message appear
Pascale Lunal wrote:
> Oops: sorry if this message appears twice but my connection broke down
> just when I clicked 'send'.
>
> Hello,
>
> I am currently writing a search query in PHP to:
>
> 1. search in MySQL database (not in one table but in all the tables
Oops: sorry if this message appears twice but my connection broke down just
when I clicked 'send'.
Hello,
I am currently writing a search query in PHP to:
1. search in MySQL database (not in one table but in all the tables of the
whole database),
2. search when more than one sea
The following script, with some edits, has allowed access to a "LOCAL" mysql
database. I have reworked it some to access a MySQL on another server I
suppose I could transfer the script to that server for loading/execution, but
I'd like to learn how one accesses a remote mySQL database (to faci
ls negotiating prices book with tips for buying',
'VE');
EXPLAIN SELET * FROM bus_search
WHERE MATCH(title,keywords) AGAINST('Best Car Deals')
Comments:
Impossible WHERE noticed after reading const tables
>>I poste
I posted a question regarding a search query we are trying to get to work, and
was hoping someone can tell why this query doesn't work. It should return
results as all the search criteria is there in the tables( for test purposes)
QUERY:
SELECT bi.bus_name,bi.address,bl.city,bl.state,
bl.zi
Hello All,
I have been trying to figure out why the below query doesn't quiet produce the
results we are looking for. I was hoping some one maybe able to shed some lite
on why QUERY #3 returns the wrong results. If addition information is needed,
please feel free to respond privately, off the li
Hello All,
MySQL version 3.23.33
I was hoping someone maybe able to offer some suggestion on a search query I've
been working for a day or so, but seems to be getting no where fast!
I've attached the tables and test inserts I'm working with. This is for a
business referral sear
Hello All,
MySQL version 3.23.33
I was hoping someone maybe able to offer some suggestion on a search query I've
been working for a day or so, but seems to be getting no where fast!
I've attached the tables and test inserts I'm working with. This is for a
business referral sear
#
# Table structure for table 'bus_info'
#
CREATE TABLE bus_info (
info_id int(11) unsigned DEFAULT '' NOT NULL auto_increment,
bus_name varchar(100) DEFAULT '' NOT NULL ,
contact_fname varchar(20) DEFAULT '' NOT NULL ,
contact_lname varchar(20) DEFAULT '' NOT NULL ,
refer_by int(8))
21 matches
Mail list logo
