Re: Searching For Modules In a DB

Carlos Mennens schrieb: > I have a database called 'gaming' and with in that database there are > several tables and data. I was asked to find a module called 'ako > ldap' and disable it (setting it from 1 to 0). My question is how in > MySQL do I search for a string if I don't even know what tab

Re: Searching For Modules In a DB

Recently I went through a link related to this question. check the below link. I haven't checked the script, hope it will be useful. http://tequilaphp.wordpress.com/2010/07/05/searching-strings-in-a-database-and-files/ Regards, Jay MySQL DBA On Thu, Aug 12, 2010 at 2:31 AM, Carlos Mennens wrote:

Re: searching serialized data stored in mysql

On 09/08/2010 18:33, Norman Khine wrote: hello, i have a table called checkout, this has a row called products which has contains a python dictionary data, like http://pastie.org/1082137 {products: [{productId: 123, productName: APPLE, productPrice: 2.34, productUrl: http://appple-

Re: Searching for recent book available in Germany

Hello Claudio, Am 2008-12-28 17:02:53, schrieb Claudio Nanni: > Hi Michelle, > > I would definitely suggest DuBois' last book(28. September 2008): > > http://www.amazon.de/MySQL-Developers-Library/dp/0672329387/ref=sr_1_3?ie=UTF8&s=books-intl-de&qid=1230479926&sr=8-3 > > It is well written, cl

Re: Searching for recent book available in Germany

Hi Michelle, I would definitely suggest DuBois' last book(28. September 2008): http://www.amazon.de/MySQL-Developers-Library/dp/0672329387/ref=sr_1_3?ie=UTF8&s=books-intl-de&qid=1230479926&sr=8-3 It is well written, clear and complete, look no further. Aloha! Claudio Nanni 2008/12/28 Michel

Re: Searching for Dates

To you all, Thanks for your input. The "TO_DAYS(date_col)%4 = TO_DAYS('2006-4-17')% 4" where statement worked perfectly. And, thanks for the reference to the manual. It can be a bit daunting for a newbie. Bob Cooper > Dan: > > Thanks! > > Jim > > > In the last episode (Mar 18), Jim Ginn said

Re: Searching for Dates

Dan: Thanks! Jim > In the last episode (Mar 18), Jim Ginn said: >> > In the last episode (Mar 16), Bob Cooper said: >> >> I am working with MySQL ver 5.1 on a Ubuntu Linux x86_64. I am new >> >> to both SQL and MySQL. I have been able to query out most of the >> >> data I need from my tables wi

Re: Searching for Dates

In the last episode (Mar 18), Jim Ginn said: > > In the last episode (Mar 16), Bob Cooper said: > >> I am working with MySQL ver 5.1 on a Ubuntu Linux x86_64. I am new > >> to both SQL and MySQL. I have been able to query out most of the > >> data I need from my tables without any issues but his on

Re: Searching for Dates

Dan: I've used the TO_DAYS on a SELECT statement ie: SELECT * FROM properties WHERE (TO_DAYS(NOW()) - TO_DAYS(CreationDate) = 1) ORDER BY id DESC however it didn't seem to take advantage or use the index on that field (ie. CreationDate) ... Jim > In the last episode (Mar 16), Bob Cooper said:

Re: Searching for Dates

In the last episode (Mar 16), Bob Cooper said: > I am working with MySQL ver 5.1 on a Ubuntu Linux x86_64. I am new to > both SQL and MySQL. I have been able to query out most of the data I > need from my tables without any issues but his one has stumped me. > > I am trying to query data associate

Re: Searching Fields for a SubString

Thanks for the help. As often happens in these situations, a little searching and experimentation got me a workable answer before any replies arrived. In my case, I was able to use the LOCATE operator, i.e. select idx, lname,schedalonerscs from usrs where LOCATE(",7,", schedalonerscs) != 0; I'

Re: Searching Fields for a SubString

Dave, you could just use a LIKE statement SELECT * FROM table WHERE mystring LIKE "%,2,%" Of course if it is at the beginning or end, or the only item, it may look like '2' '2,' or ',2' and not ',2,' so this would work in all cases I think: WHERE (mystring LIKE "%,2,%" OR mystring LIKE "2,%" OR

Re: Searching for a MySQL Admin at TiVo

This person ought to be in USA? ""Leann Das"" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > If anyone would be interested in a contract, please contact me! > > Thanks! > > > Leann Das > Recruiter, TiVo > http://www.tivo.com/

Re: Searching through an alphabetical range

Depending on the size of your table, it can be faster using SELECT lastname FROM employee WHERE lastname BETWEEN 'm' AND 'z' GROUP BY lastname; On a table with 2,5 Mill. records the speed diff is over 1000% on my system. ViSolve DB Team wrote: Hello Paul, You can try this: SELECT DISTINCT

Re: Searching through an alphabetical range

Hello Paul, You can try this: SELECT DISTINCT lastname FROM employee WHERE lastname BETWEEN 'm' AND 'z'; Thanks, ViSolve DB Team. - Original Message - From: "Paul Nowosielski" <[EMAIL PROTECTED]> To: Sent: Friday, July 21, 2006 10:33 PM Subject: Searching through an alphabetical r

RE: Searching through an alphabetical range

'z'; > +-+ > > | 'seal' >= 'm' AND 'seal' <= 'z' | > > +-+ > > | 1 | > > +---------+ > 1 row in

Re: Searching through an alphabetical range

+-+ > > | 'seal' >= 'm' AND 'seal' <= 'z' | > > +-+ > > | 1 | > > +-----+ > 1 row in set (0.00 sec) > > mysql> > > '

RE: Searching through an alphabetical range

--+ | 1 | +-+ 1 row in set (0.00 sec) mysql> 'zz' will probably do the trick, though. Tim > -Original Message- > From: Paul Nowosielski [mailto:[

Re: Searching through an alphabetical range

I have the solution: SELECT DISTINCT email_address FROM mailing_list WHERE last_name >= 'm' AND last_name <= 'z' Thank you, -- Paul Nowosielski Webmaster On Friday 21 July 2006 11:03, Paul Nowosielski wrote: > Dear All, > > I need to write a query that searches last names between the range

Re: searching for words with special chars

On 2006-04-01, at 13:17, Octavian Rasnita wrote: Hi, Is it possible to create a query that searches for records which contains words with special chars and with their english correspondents? For example, if a user searches for "mata", I want to return all the records that contain the wo

Re: Searching a large table

well, you'd still have to use limit and offset with your search table would you store a different table for each unique query? That sounds like a lot of [temporary?] tables. are you doing ore than 3-4 table joins on ths one fulltext search query? If not, it's probably more work. If your q

Re: Searching a large table

Hi Sheeri: Yes, you are misunderstanding my question. I certainly know how to limit my resultset to certain rows. I'm asking more about the effiencency of searching large volumes of data. Is making a search table like vBulletin does a good mechanism to avoid resource contention on the main tabl

Re: Searching a large table

Sounds like you want LIMIT and OFFSET -- everything after my name and before your post is copied from the doc at http://dev.mysql.com/doc/refman/4.1/en/select.html (or am I misunderstanding your question?) -Sheeri The LIMIT clause can be used to constrain the number of rows returned by the SEL

Re: searching for words with special chars

There at least two ways to accomplish this. The easy way is to use the LIKE operator: See http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html Regards Keith In theory, theory and practice are the same; in practice they are not. On Sat, 1 Apr 2006, Octavian Rasnita wrote: > To: mys

Re: searching in an 'AND' style of query

Quoting Chris <[EMAIL PROTECTED]>: SELECT content.name FROM content as c INNER JOIN content_categories as cg ON(c.id = cg.content_id) INNER JOIN categories as g ON(cg.category_id = g.id) WHERE g.id IN (3,5,9) GROUP BY c.id HAVING 3 = COUNT(*) Thanks, Chris - that did the trick alright! I use

Re: searching in an 'AND' style of query

starmonkey wrote: q: I want to pull a distinct list of "content" that have a "category" (we have a content_categories table linking content ids with category ids), BUT I want it to be able to work from multiple categories in an AND fashion. the table structure is, roughly: content: id nam

Re: searching through a mysql db/tbl

Hello. > 1) i'm trying to figure out how to allow a user to search through a Full-Text search functions might be helpful. See: http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html > 2) if i have a query that produces a number of rows, how/what would i need > to do, to limit the numbe

Re: searching through a mysql db/tbl

bruce wrote: 1) i'm trying to figure out how to allow a user to search through a query/tbl for a given string. ie, if i have the following as the result of a query: Why wouldn't you simply create the query that would produce only the rows you want (where name = '%aa%' OR email = '%aa%' OR...)?

Re: Searching "IN" a comma separated list

Vous être le bienvenue :o) Selon W Luke <[EMAIL PROTECTED]>: > On 25/06/05, Mathias <[EMAIL PROTECTED]> wrote: > > > I then write you this query which should give you the idea, and i think the > > solution : > > > > mysql> select gid,ugid,FIND_IN_SET(gid,ugid) from groups,groupsList > > -> wh

Re: Searching "IN" a comma separated list

On 25/06/05, Mathias <[EMAIL PROTECTED]> wrote: > I then write you this query which should give you the idea, and i think the > solution : > > mysql> select gid,ugid,FIND_IN_SET(gid,ugid) from groups,groupsList > -> where FIND_IN_SET(gid,ugid) > 0; > +--+-+---+

Re: Searching "IN" a comma separated list

Selon W Luke <[EMAIL PROTECTED]>: > Hi, > > Have struggled with this all day, and didn't know where else to ask. > If it's not appropriate to the list, I apologise - and advice or > pointers would be brilliant, as my head is now hurting! > > So here's the situation: > > 3 tables. f_u_groups f_gro

Re: Searching a table and replacing all instances of a string with another

Have you read the page in the manual which documents the string functions ? UPDATE your_table SET name_col = REPLACE(name_col, 'Peter', 'Paul'); Now, when you say, "all fields in a table", do you mean every row of a particular column,

Re: Searching a table and replacing all instances of a string with another

On Fri, 12 Nov 2004 22:12:29 -0500, Joshua Beall <[EMAIL PROTECTED]> wrote: > Hi All, > > I would like to search through all fields in a table, and anytime a search > string comes up, have it replace it with another string. By way of example, > let's say I wanted to replace every occurence of 'Pe

Re: Searching for an equivalent to the Oracle "POSITION" parameter

Shawn, Thanks a lot for this explanation. It works perfectly. Best, Adam [EMAIL PROTECTED] wrote: While reading http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html I found this passage " If the FIELDS TERMINATED BY and FIELDS ENCLOSED BY values are both empty (''), a fixed-row (non-delimited) format

Re: Searching for an equivalent to the Oracle "POSITION" parameter

While reading http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html I found this passage " If the FIELDS TERMINATED BY and FIELDS ENCLOSED BY values are both empty (''), a fixed-row (non-delimited) format is used. With fixed-row format, no delimiters are used between fields (but you can still have a

Re: Searching in several tabels

"Naim" <[EMAIL PROTECTED]> wrote: > I have a database with several tabels. Example: > > Database articles: > > Table1: > id > name > title > tekst > > Table2 > id > name > title > tekst > > Table3 > id > name > title > tekst > > Now I want to search for a specifik title within all the database an

Re: Searching the Docs

PROTECTED]> Sent: Wednesday, April 21, 2004 4:51 PM Subject: RE: Searching the Docs > Lou, > I normally download the html version of the manual and have a little search > feature just for it. And you are correct, I've looked for a few of your > examples and can't find a

RE: Searching the Docs

to figure out exactly what they do though. Sorry. Donny > -Original Message- > From: Lou Olsten [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 21, 2004 3:35 PM > To: [EMAIL PROTECTED] > Subject: Re: Searching the Docs > > I use the online docs extensively as I

Re: Searching the Docs

I use the online docs extensively as I am still very much in learning mode with MySQL. However, I've been frustrated recently because it appears I cannot search for an EXACT string literal, which brings me back a ton of hits I don't want. For example, I'm trying to search for the dynamic syste

Re: Searching for matching zipcode in a list of (ranges of) zipcodes

Hi all, Thanks very much for the advice, it gave me more than enough input to resolve my problem! Kind regards, Tom Hesp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Searching for matching zipcode in a list of (ranges of) zipcodes

Original Message Subject: Re: Searching for matching zipcode in a list of (ranges of) zipcodes Date: Wed, 14 Jan 2004 14:14:19 +0100 From: Mirza <[EMAIL PROTECTED]> To: Tom Hesp <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> Hi, If you rewrite ranges

RE: Searching for matching zipcode in a list of (ranges of) zipcodes

Tom, Change your database so that you have an engineer table and an engineer_zipcodes table. Each engineer can have multiple entries in the engineer_zipcodes table. Engineer Engineer_id integer auto_increment primary key Name Address Etc Create index engineer1 on engineer(engineer_id) Engineer_

RE: Searching for a realtime progress bar that uses mySQL and Flash?

n xml rather than html, then the flash works off the xml). Think of it as web service eye for the lazy guy... :) > -Original Message- > From: TheMechE [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 25, 2003 10:24 AM > To: Tom Horstmann; [EMAIL PROTECTED] > Subject:

RE: Searching for a realtime progress bar that uses mySQL and Flash?

From: Tom Horstmann [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 25, 2003 4:26 AM To: [EMAIL PROTECTED] Subject: RE: Searching for a realtime progress bar that uses mySQL and Flash? > I disagree, you can restrict access to SELECT only Sure, but no access is much more secure than restric

RE: Searching for a realtime progress bar that uses mySQL and Flash?

> I disagree, you can restrict access to SELECT only Sure, but no access is much more secure than restricted access. > and plus > any normal form > on a web page has access to a DB in much more insecure ways > (SQL injection, > etc.), What you consider insecure should not been written directl

RE: Searching for a realtime progress bar that uses mySQL and Flash?

I disagree, you can restrict access to SELECT only and plus any normal form on a web page has access to a DB in much more insecure ways (SQL injection, etc.), and as I said, it must be a 'real-time' progress meter without refreshing the .php/.html page. Javascript is not able to query the DB. A

RE: Searching for a realtime progress bar that uses mySQL and Flash?

> I've scoured the web and can't seem to find any examples, and > can't find > anything that shows flash actually making the connection to > mysql on its > own. They all seem to rely upon PHP or something passing the value. > Refreshing the page is not acceptable. Flash is executed in the client

RE: Searching all db tables for a column name in MySQL - how? can I?

lto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 11:30 AM To: [EMAIL PROTECTED] Subject: RE: Searching all db tables for a column name in MySQL - how? can I? Chris: Your syntax and all documented syntax is for querying column names in just one table. My question is "How do I search for a speci

RE: Searching all db tables for a column name in MySQL - how? can I?

Chris: Your syntax and all documented syntax is for querying column names in just one table. My question is "How do I search for a specific column name in ALL tables? Chris <[EMAIL PROTECTED]> wrote: SHOW COLUMNS FROM table_name LIKE 'Identifier'; should work. It's all in here, jsut search t

RE: Searching all db tables for a column name in MySQL - how? can I?

SHOW COLUMNS FROM table_name LIKE 'Identifier'; should work. It's all in here, jsut search the page for SHOW COLUMNS: http://www.mysql.com/doc/en/Show_database_info.html Chris -Original Message- From: Patricia LaRue [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 11:02 AM To:

Re: searching for %

On Sunday, September 07, 2003 10:27 PM CEST, Wayne wrote: > Hi All, > > silly question... does anyone know how to search for '%'? i.e. > overriding the normal wildcard use > > Wayne select anything from table where col like "...\%..." mysql manual: manual_Reference.html#Functions (i've just look

Re: Searching on Two Keys with OR?

Joshua, Joshua Spoerri wrote: On Tue, 5 Aug 2003, Alexander Keremidarski wrote: MySQL will never use any index for small tables. With just few rows using index adds overhead only. Table scan is faster in such cases. This is docummented behaviour. is 100,000 rows small? my simple OR queries take

Re: Searching on Two Keys with OR?

> "ORing on two different fields" is what I have been asking about :). This is not optimized, and I don't think it is set to be optimized until 5.1 (as per someone else's comment). > Using a composite index was suggested This is bad information. It works for AND, not for OR. You have two workar

Re: Searching on Two Keys with OR?

I think I have a similar problem... I am thinking abeout switching to a different DBMS. Can anyone tell me something about PostgreSQL? Thanks in advance, Martin. Am Donnerstag, 07.08.03, um 03:32 Uhr (Europe/Zurich) schrieb Steven Roussey: "ORing on two different fields" is what I have been ask

Re: Searching on Two Keys with OR?

Joshua Spoerri wrote: On Tue, 5 Aug 2003, gerald_clark wrote: You are ORing on two different fields. The index cannot be used to check the value of z for an OR. "ORing on two different fields" is what I have been asking about :). Using a composite index was suggested, which strangely se

Re: Searching on Two Keys with OR?

Joshua, Joshua Spoerri wrote: Forgive me, that example is no good. Oddly, it works, but the following does not: mysql> create temporary table x (y int, z int, q int, index (y, z)); insert into x values (1,2,3), (3,4,5), (5,6,7); explain select * from x where y = 1 or z = 1; MySQL will never use

Re: Searching on Two Keys with OR?

Steven Roussey wrote: >> "ORing on two different fields" is what I have been asking about :). > This is not optimized, and I don't think it is set to be optimized > until 5.1 (as per someone else's comment). >> Using a composite index was suggested > This is bad information. It works for AND, not

Re: Searching on Two Keys with OR?

You're saying that when you try my example, it does use the composite index? Even with an extra column in the table that isn't being searched on (q below)? If so, do you know of anything in version 4.0.13 that could cause this bad behaviour? i'm using the default configuration unchanged. On Tue,

Re: Searching on Two Keys with OR?

On Tue, 5 Aug 2003, gerald_clark wrote: > You are ORing on two different fields. The index cannot be used to > check the value of z for an OR. "ORing on two different fields" is what I have been asking about :). Using a composite index was suggested, which strangely seems to work only when there

Re: Searching on Two Keys with OR?

On Tue, 5 Aug 2003, Alexander Keremidarski wrote: > MySQL will never use any index for small tables. With just few rows using index > adds overhead only. Table scan is faster in such cases. This is docummented > behaviour. is 100,000 rows small? my simple OR queries take longer than a second. my

Re: Searching on Two Keys with OR?

You are ORing on two different fields. The index cannot be used to check the value of z for an OR. Why are you cross posting? Joshua Spoerri wrote: On Tue, 5 Aug 2003, Alexander Keremidarski wrote: MySQL will never use any index for small tables. With just few rows using index adds overhead

Re: Searching on Two Keys with OR?

Thanks for the suggestion. This is not ideal for a couple of reasons: I'm using an object-relational layer that would have to be hacked up something fierce, and my actual query would be pretty hairy: (select * from t1 where a=x union select t1.* from t1,t2 where t1.b=t2.b and t2.c=y union select

Re: Searching on Two Keys with OR?

Have you tried using the UNION statement? That worked great for me. So, something like: (select * from sometable where f1 = 123) UNION (select * from sometable where f2 = 123) ? -- Rudi Benkovic [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql

Re: Searching on Two Keys with OR?

Forgive me, that example is no good. Oddly, it works, but the following does not: mysql> create temporary table x (y int, z int, q int, index (y, z)); insert into x values (1,2,3), (3,4,5), (5,6,7); explain select * from x where y = 1 or z = 1; Query OK, 0 rows affected (0.00 sec) Query OK, 3 ro

Re: Searching on Two Keys with OR?

That doesn't seem to work (and not with bigger table either): mysql> create temporary table x (y int, z int, index (y), index(z)); insert into x values (1,2), (3,4), (5,6); explain select * from x where y = 1 or z = 1; Query OK, 0 rows affected (0.00 sec) Query OK, 3 rows affected (0.00 sec) Rec

Re: Searching on Two Keys with OR?

Joshua, Joshua Spoerri wrote: Which version is targetted for optimization of OR searching on two keys, that is, "select * from sometable where f1 = 123 or f2 = 123", as described in http://www.mysql.com/doc/en/Searching_on_two_keys.html ? As described there MySQL can use only one index per table.

Re: Searching Archives

Hi Ernest, There are several ways to do it. Most pages like www.mysql.com or mirrors (geocrawler etc.) have a build in search function. http://lists.mysql.com/ (watch for the Archive links) http://lists.mysql.com/list.php?list=mysql#b (link for the general list - the one you are subscript to to

Re: Searching Archives

Ernest Pianalto <[EMAIL PROTECTED]> wrote: > > I just joined this list and would like to search the archives before I ask a > question. I there a way to search. Here you can find list of searchable mailing list archives: http://www.mysql.com/documentation/lists.html -- For technical

RE: Searching on indexed char field...

On 10 Mar 2003, at 16:31, Tab Alleman wrote: > I was thinking if you do a select on a char[50] and the whole field > is indexed, wouldn't the search algorithm know exactly where to go > to look for a match, as opposed to - if only the first 20 characters > are indexed - finding all of the possible

RE: Searching on indexed char field...

Benjamin Pflugmann wrote: > If you have 256MB, the one may fit into memory, > the other may not and therefore requires additional disk reads. Ah, see.. I hadn't thought of disk reads. I was thinking if you do a select on a char[50] and the whole field is indexed, wouldn't the search algorith

Re: Searching on indexed char field...

On Mon 2003-03-10 at 15:06:05 -0500, [EMAIL PROTECTED] wrote: > > > > If you're indexing all 50 characters, index fewer of them. > > Not that I think you're wrong, but help me understand, please: > > It seems to me that this would cause the index creation to go faster, > but the execution of the

RE: Searching on indexed char field...

> > If you're indexing all 50 characters, index fewer of them. > Not that I think you're wrong, but help me understand, please: It seems to me that this would cause the index creation to go faster, but the execution of the SELECT query to, if anything, go slower...? I'm probably wrong, though,

Re: Searching on indexed char field...

sql, mysql... oops, forgot the quotes>> You might also try indexing only a portion of the char[50] index. >> index (UserName(20)), for example... David - Before posting, please check: http://www.mysql.com/manual.php

Re: Searching on indexed char field...

sql, mysql... You might also try indexing only a portion of the char[50] index. index UserName(20), for example... David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mys

Re: Searching on indexed char field...

At 13:39 -0500 3/10/03, Jason West wrote: Does anyone know of a way to speed up seek time when selecting based on an indexed char field? I have a query that I'm executing ('select * from Table where UserName = myname') and it takes approximately 7 seconds to execute this 1000 times (UserName is cha

RE: Searching on indexed char field...

This may not be the solution you are looking for, but if you are executing ths query 1000 times, it must be in a program somewhere, so why not execute it once, pullout the UserID the run the rest on UserID? Hope this helps. Roger -Original Message- From: Jason West [mailto:[EMAIL PROTECTE

Re: Searching text in a big table

Check out full-text indexing: http://www.mysql.com/doc/en/Fulltext_Search.html I don't think there's any other way to improve searching in unstructured text using MySQL -steve At 3:58 PM -0700 8/27/02, Sanny Sun wrote: >Hi there, >I have a big table which has 25 rows.

Re: searching in 2 databases?

Ilyas, Monday, August 12, 2002, 11:22:52 AM, you wrote: IK> Is it possible in Mysql to search in 2 databases with only one search IK> statement? Do you mean use tables from different database? If the databases are located on the same MySQL server - yes. For example: SELECT * FROM database1.a,

Re: searching in 2 databases?

Hi, If wish to search on two database which are in the same server machine , the answer is yes. Ex: DB A,with table A1 DB B,with table B1 select * from A.A1,B.B1; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROT

Re: Searching through a MySQL-driven website

At 05:00 AM 6/26/2002, you wrote: >I run a MySQL/PHP-based website. In an attempt to make some search >functionality, I search a few specific tables that I find relevant and look >in certain fields when performing a search. A query will generally look >something like this: > >SELECT * FROM Books W

Re: Searching through a MySQL-driven website

Hi! You can try FULLTEXT search, implemented in MySQL, or consider installing specialized Web search engine. Eivind A. Sivertsen wrote: > I run a MySQL/PHP-based website. In an attempt to make some search > functionality, I search a few specific tables that I find relevant and look > in cert

RE: Searching

* John Berman [...] > SQL = "Select * From tbl_births Where RegDistrict Like '%"&term&"%'" > SQL = SQL & " Or county Like '%"&term&"%'" > SQL = SQL & " Or Date Like '%"&term&"%'" > SQL = SQL & " Or pofbirth Like '%"term&"%'" > SQL = SQL & " Or Forenames Like '%"&term&"%'" > etc > > this if fine fo

Re: Searching on multiple indexed columns

Hi Kim, On Thu, 2002-03-21 at 09:15, Kim Kohen wrote: > G'day Arjen Indeed, hi fellow Aussie ;-) > > FULLTEXT search generally uses an index (the FULLTEXT index), so the > > server will not use an index on Writer. > So is an index on Writers worthless in this circumstance? My concern would > b

Re: Searching on multiple indexed columns

G'day Arjen > FULLTEXT search generally uses an index (the FULLTEXT index), so the > server will not use an index on Writer. > So far for the answer to Kim. So is an index on Writers worthless in this circumstance? My concern would be if someone did a query using the writer's name as the _on

Re: Searching on multiple indexed columns

On Wed, 2002-03-20 at 12:56, Paul DuBois wrote: > >With Story_Content, we're happy to use the stricter MATCH selects. So is > >it possible to do something like Select * from stories where > >MATCH(Story_Content) against ('param1') AND Writer LIKE "param2%" or am I > >barking up the wrong (b-) tr

Re: Searching on multiple indexed columns

At 13:28 +1100 3/20/02, Kim Kohen wrote: >G'day Paul > >Thank you for your response. > >> Sure, but no index will be used for the LIKE pattern match part of the >> query because your pattern doesn't begin with a literal string. > >I realised after I sent the previous post that I should have

Re: Searching on multiple indexed columns

G'day Paul Thank you for your response. > Sure, but no index will be used for the LIKE pattern match part of the > query because your pattern doesn't begin with a literal string. I realised after I sent the previous post that I should have omitted the first '%'. I had mentally noted this f

Re: Searching on multiple indexed columns

At 11:59 +1100 3/20/02, Kim Kohen wrote: >Hi All, > >My apologies for asking what may be a very newbie question. I'm having >trouble getting my head around searching multiple indexed columns. I have >read the MySQL docs 5.4.3, 5.4.4, 5.4.5 and 6.8 full text and have scoured >Paul's book but haven'

Re: Searching for the configuration file

Hi. Depending on from what source you installed MySQL, there may be none yet and you have to create it (I think this is the case for the RPMs). The places where MySQL looks for the file are listed here: http://www.mysql.com/doc/O/p/Option_files.html Bye, Benjamin. On Thu, Dec 13, 200

Re: Searching for partial dates

Is the date really stored as an integer? You say so, but then you're trying a wildcard (i.e. char) search. If so, try this (pretending date_int is your date stored as an integer column in the table large_table):

Re: Searching for partial dates

From: jeff <[EMAIL PROTECTED]> > I need to be able to search by partial dates. > What is the best way to search? You ~could~ do something harsh like: SELECT *, substring(myDate, 1, 2) as month FROM myFunnyTable WHERE month = '06' But unless you are only going to need this data

Re: searching columns with lots of text

On 13 Aug 2001 21:11:21 -0700, Michael Collins wrote: > Is there a common approach to searching within text columns that > contain fairly large blocks of text (30,000 - 65,000 characters)? Is Oh NO! Sorry, I messed my mail folders. Please forget about my previous mail :( -- For technical sup

Re: searching columns with lots of text

On 13 Aug 2001 21:11:21 -0700, Michael Collins wrote: > Is there a common approach to searching within text columns that > contain fairly large blocks of text (30,000 - 65,000 characters)? Is > the recommendation, simply don't do it or is there some sort of > workaround? I suppose one can sear

Re: Searching in a mysql table

I hope i'm asking in the right place, as i've asked around alot and haven't gotten an answer. Would it be inefficient to use the command "SELECT * FROM users_info WHERE name LIKE "%phil%" and company like "%" and address like "%";" Note the single % by itself. Would this slow down the s

Re: Searching in a mysql table

joe schrieb am Freitag, 3. August 2001, 07:46:09: > Would it be inefficient to use the command "SELECT * FROM users_info WHERE > name LIKE "%phil%" and company like "%" and address like "%";" What use have > and company like "%" and address like "%" Omit it and you will be just as fine. If y

RE: searching multiple text fields

> I need to build a search utility which can query records based > on multiple text parameter, > my table will have about 10 fields and users can search on > 3-5 parameters in one query. is there any way to achieve this > other than doing a full table scan. http://www.mysql.com/doc/F/u/Fullt

Re: Searching records ?'s

indexing the entire large text column really drags performance down, and consumes big hunks of disk space. mysql has a good regexp facility. rtfm At 10:52 PM 7/6/01 -0700, you wrote: >Hi Everyone, > >I'm writing a script using perl for a search function. I have a large >text column that I want

Re: Searching keywords in a LONGTEXT field

On Thu, Apr 26, 2001 at 09:54:56AM +0200, [EMAIL PROTECTED] wrote: > we're just facing a "challenging" problem ... we have a MySQL lessons > learned database. In two fields of the main table (LONGTEXT) we have the > "description" and the "solution". You could think of two short abstracts, > regar

Re: Searching text fields

> database,sql,query > Hi All, > > Is there a nice way to take a search string eg > "America spying China" and search a text or > blob field for occurances of all of the words > in the text in any order (ie not just a literal > string match, but the equivalent of > AND X LIKE "%America%" AND X

Re: searching tables.

Hi John, On Wed, Mar 21, 2001 at 09:51:10AM +1000, John Nielsen wrote: > Hi Everyone, > > This question may have been asked before, but i could not find it in the > archives, so i was wondering if someone could help me out. > > Say i had the following table: > > > ++--

  1   2   >