Re: Postal code searching

2012/04/25 10:14 +0100, Mark Goodge On 24/04/2012 17:24, Tompkins Neil wrote: >How about if I want to only return postal codes that are like W1U 8JE >not W13 0SU. > >Because in this example I have W1 as the postal code and W13 is the other >postal code No, you don't. In this example you

Re: Postal code searching

Thanks for your very detailed response Mark. Most helpful. On Wed, Apr 25, 2012 at 10:14 AM, Mark Goodge wrote: > On 24/04/2012 17:24, Tompkins Neil wrote: > >> How about if I want to only return postal codes that are like W1U 8JE >> not W13 0SU. >> >> Because in this example I have W1 as the

Re: Postal code searching

If nothing else a great intro to the UK postcode. I find this very interesting/useful. Thanks Mark. On Wed, Apr 25, 2012 at 10:14 AM, Mark Goodge wrote: > On 24/04/2012 17:24, Tompkins Neil wrote: > >> How about if I want to only return postal codes that are like W1U 8JE >> not W13 0SU. >> >> B

Re: Postal code searching

On 24/04/2012 17:24, Tompkins Neil wrote: How about if I want to only return postal codes that are like W1U 8JE not W13 0SU. Because in this example I have W1 as the postal code and W13 is the other postal code No, you don't. In this example you have W1U as one outbound code and W13 as the ot

Re: Postal code searching

Original Message- >>> From: Tompkins Neil [mailto:neil.tompk...@googlemail.com] >>> Sent: Tuesday, April 24, 2012 9:11 AM >>> To: [MySQL] >>> Subject: Postal code searching >>> >>> Hi >>> >>> I've a number of differe

Re: Postal code searching

inguish digits from letters, but won't help you isolate them. > >> -Original Message- >> From: Tompkins Neil [mailto:neil.tompk...@googlemail.com] >> Sent: Tuesday, April 24, 2012 9:11 AM >> To: [MySQL] >> Subject: Postal code searching >> >> Hi >>

RE: Postal code searching

9:11 AM > To: [MySQL] > Subject: Postal code searching > > Hi > > I've a number of different postal codes in a system for example > > WC1B 5JA > WC1H 8EJ > W1J 7BX > W1H 7DL > NW1 1NY > > I can use like statements for example > > SELECT * FROM posta

Re: Postal code searching

On Tue, Apr 24, 2012 at 12:24 PM, Tompkins Neil wrote: > How about if I want to only return postal codes that are like W1U 8JE > not W13 0SU. > > Because in this example I have W1 as the postal code and W13 is the other > postal code Perhaps something like following? Though, to be honest, I'm not

Re: Postal code searching

On 24/04/2012 17:24, Tompkins Neil wrote: How about if I want to only return postal codes that are like W1U 8JE not W13 0SU. Because in this example I have W1 as the postal code and W13 is the other postal code Then you'd do: like 'W1 %' to return anything starting W1 like 'W13 %' to return an

Re: Postal code searching

How about if I want to only return postal codes that are like W1U 8JE not W13 0SU. Because in this example I have W1 as the postal code and W13 is the other postal code On Tue, Apr 24, 2012 at 5:18 PM, Gary Smith wrote: > On 24/04/2012 17:16, Gary Smith wrote: > >> http://dev.mysql.com/doc/**r

Re: Postal code searching

On 24/04/2012 17:16, Gary Smith wrote: http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html Specifically, replace % with _ as this means "match one character" not "match any number of characters". So, you can do: like "W1 %" like "W1_ %" etc. Oh, and you can also get really

Re: Postal code searching

On 24/04/2012 17:11, Tompkins Neil wrote: Hi I've a number of different postal codes in a system for example WC1B 5JA WC1H 8EJ W1J 7BX W1H 7DL NW1 1NY I can use like statements for example SELECT * FROM postal_codes WHERE zip LIKE 'W1%' giving me W1J 7BX W1H 7DL In addition I have a number

Postal code searching

Hi I've a number of different postal codes in a system for example WC1B 5JA WC1H 8EJ W1J 7BX W1H 7DL NW1 1NY I can use like statements for example SELECT * FROM postal_codes WHERE zip LIKE 'W1%' giving me W1J 7BX W1H 7DL In addition I have a number of abbreviated postal codes like W1 WC1 WC2

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

Searching For Modules In a DB

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 table to search in? I know how to sea

Re: searching serialized data stored in mysql

ake a search on this data, for example if i want to search for a range of products with a price between €2 - €4 is this the correct way to store this type of data? No, it isn't, not if you're going to be searching for individual elements of the array. Your products table should rea

searching serialized data stored in mysql

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-fruits.net, productDescription: "nice juicy

Re: mysql spatial functions (Was: Best index for searching on lat / long data i.e. decimal vs. float)

It works great for me. After working out the bugs and adding the spatial index I am now searching in the 0.05 second timeframe vs. minutes otherwise. Dan On Sun, 2 May 2010 23:39:41 -0700, Rob Wultsch wrote: >>>> >> >>> On Sat, May 1, 2

Re: mysql spatial functions (Was: Best index for searching on lat / long data i.e. decimal vs. float)

>>> >> >>> On Sat, May 1, 2010 at 11:12 PM, dan wrote: >>> >> >>> >>> >> >>> >> Can any one help me with understanding the mysql spatial >>> >> functions? >>> >>  I >>> >> can >>> >> only seem to find bits and pieces of how-to's etc. >>> >> >>> >> I have an exist

Re: mysql spatial functions (Was: Best index for searching on lat / long data i.e. decimal vs. float)

Ok... I am close I forgot an extra () in my POLYGON statement: UPDATE `grid` SET lsd_poly = GeomFromText(CONCAT('POLYGON((',n,' ',e,', ',s,' ',e,', ',s,' ',w,', ',n,' ',w,', ',n,' ',e,'))')); (I also created a new GEOMETRY lsd_poly column rather than the poly POLYGON one). Now I nee

Re: mysql spatial functions (Was: Best index for searching on lat / long data i.e. decimal vs. float)

poly is a polygon but I have not added a spatial index yet. Here's where it gets weird. I tried adding dummy data: mysql> SET @bbox = 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0))'; Query OK, 0 rows affected (0.01 sec) mysql> update grid set poly = GeomFromText(@bbox); Query OK, 7876282 rows

Re: mysql spatial functions (Was: Best index for searching on lat / long data i.e. decimal vs. float)

Tried it but no luck: mysql> UPDATE `grid` SET poly = GeomFromText(CONCAT('POLYGON(',n,' ',e,', ',s,' ',e,', ',s,' ',w,', ',n,' ',w,', ',n,' ',e,')')); Query OK, 0 rows affected (2 min 3.86 sec) Rows matched: 7876282 Changed: 0 Warnings: 0 mysql> select poly from grid limit 10; +--

Re: mysql spatial functions (Was: Best index for searching on lat / long data i.e. decimal vs. float)

I am still lost... I tried this: UPDATE `grid` SET poly = PolygonFromText(CONCAT('POLYGON(',n,' ',e,', ',s,' ',e,', ',s,' ',w,', ',n,' ',w,', ',n,' ',e,')')); I had my delimiters mixed up and I know my CONCAT worked: mysql> select CONCAT('POLYGON(',n,' ',e,', ',s,' ',e,', ',s,' ',w,', ',

Re: mysql spatial functions (Was: Best index for searching on lat / long data i.e. decimal vs. float)

Dan, I think you are trying to create a polygon based on the values in other columns in the same row. I think these other columns are named `n` and so on. Your mistake is that you are creating a text string, "POLYGON(..)" and embedding column names inside it. That won't work. Those column

Re: mysql spatial functions (Was: Best index for searching on lat / long data i.e. decimal vs. float)

I have seen that but I am stuck at just populating my POLYGON column (poly). I have tried this: UPDATE `grid` SET poly = PolygonFromText('POLYGON(`n` `e`, `s` `e`, `s` `w`, `n` `w`, `n` `e`)'); but my poly column just reports back NULL. the n, e, s & w columns are decimal lat / long da

mysql spatial functions (Was: Best index for searching on lat / long data i.e. decimal vs. float)

Can any one help me with understanding the mysql spatial functions? I can only seem to find bits and pieces of how-to's etc. I have an existing table of lat / long data representing unique boundaries i.e. rectangles and I want to search the table to find the rectangle that bounds a specific

Re: Best index for searching on lat / long data i.e. decimal vs. float

On Sat, 01 May 2010 15:28:46 -0500, mos wrote: > > SELECT * FROM `grid`� force index(section) WHERE n > 49.012 AND s < 49.012 > AND e > > 110.0244 AND w < 110.0244; > > It should give you the answer around 0.1 seconds. Give it a try. :-) > > Mike It actually makes it worse by ab

Re: Best index for searching on lat / long data i.e. decimal vs. float

On Fri, 30 Apr 2010 17:14:06 -0500, mos wrote: > At 04:54 PM 4/30/2010, you wrote: > > Use Explain in front of your Select statement to see how many indexes it is mysql> explain SELECT * FROM `grid` WHERE n > 49.012 AND s < 49.012 AND e > 110.0244 AND w < 110.0244; ++-+-

Re: Best index for searching on lat / long data i.e. decimal vs. float

At 04:54 PM 4/30/2010, you wrote: I have a table with over 8 million rows of lat / long data all currently in decimal(12,8) format (actually some in float(12,8)). First question - should I have these all in decimal or float? I can't think of any reason why I would actually do any math via mysq

Best index for searching on lat / long data i.e. decimal vs. float

I have a table with over 8 million rows of lat / long data all currently in decimal(12,8) format (actually some in float(12,8)). First question - should I have these all in decimal or float? I can't think of any reason why I would actually do any math via mysql with this data. I am just ru

Re: Fulltext Match BOOLEAN MODE not searching integers

Hi I found by using the REPAIR command it is now working. Thanks, Neil On Wed, Mar 31, 2010 at 5:38 PM, Tompkins Neil wrote: > Hi Mark > > I did infact change the value of ft_min_word_len to 1. Rebuild the indexes > using REPAIR table name. But it didn't appear to have any affect. > > Cheers

Re: Fulltext Match BOOLEAN MODE not searching integers

Hi Mark I did infact change the value of ft_min_word_len to 1. Rebuild the indexes using REPAIR table name. But it didn't appear to have any affect. Cheers Neil On Wed, Mar 31, 2010 at 5:29 PM, Mark Goodge wrote: > On 31/03/2010 16:52, Tompkins Neil wrote: > >> Hi >> >> I have the following

Re: Fulltext Match BOOLEAN MODE not searching integers

On 31/03/2010 16:52, Tompkins Neil wrote: Hi I have the following fulltext search which appears to work fine for string phrases. However if I search like just "51" which is part of the string name like 51 Blue Widget in the table it doesn't return any results. However if I search like "bl" it r

Fulltext Match BOOLEAN MODE not searching integers

Hi I have the following fulltext search which appears to work fine for string phrases. However if I search like just "51" which is part of the string name like 51 Blue Widget in the table it doesn't return any results. However if I search like "bl" it returns the 51 Blue Widget result. My query

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

Searching for recent book available in Germany

Hello *, I am owner and maintainer of some very huge (several TBytes) PostgreSQL databases since nearly 10 years and now I have to use for a customer MySQL since his Closed Source Application disallow the use of any other SQL databases even it use no special functions... However, I have to

mysql cli aborts when searching for binary data

Hi, As my mysql command line utility aborts when searching for certain characters in a binary field (it affects bash as well), I decided to convert these characters via CHAR(character) instead, like this: select binary_column from my_table where binary_column like CONCAT (CHAR(3),&#x

Re: Hypothetical design question regarding keyword searching

Greetings, Buy 'Building Scalable Web Sites' [http://www.oreillynet.com/pub/pr/1582], authored by the chief architect of Flickr. Among other interesting topics, he describes the system they use for full-text search. Its pretty simple, though this is just one of the ways you can solve this problem

Re: Hypothetical design question regarding keyword searching

Ysgrifennodd Scott Haneda: I have been looking at stock photo sites lately, started wondering how they are doing their keyword searched. Given a potential for millions of images, each with x keywords, I have come up with two approaches... Is this the sort of thing you're looking for: htt

Hypothetical design question regarding keyword searching

I have been looking at stock photo sites lately, started wondering how they are doing their keyword searched. Given a potential for millions of images, each with x keywords, I have come up with two approaches... Approach one Images table, with a parent id Keywords table, each keyword would be its

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

Searching for Dates

Hi, 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 associated with specific dates. The dates are not sequential

Re: Full-text searching with quoted bind variables

ssage - From: "William Langshaw" <[EMAIL PROTECTED]> To: Sent: Wednesday, November 29, 2006 12:54 AM Subject: Full-text searching with quoted bind variables I am using Full-Text searching with In Boolean Mode. I am generating my query by using binding parameters. If a user typ

Full-text searching with quoted bind variables

I am using Full-Text searching with In Boolean Mode. I am generating my query by using binding parameters. If a user types in a quoted string on the search form (in order to match that string as-is), the binding mechanism escape it with a backslash. The query runs fine and it appears to return

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,", schedalone

Re: Searching Fields for a SubString

O(N) unless indexing of some kind is used. My explanation above might be confusing, so let me give an example that will give the same answer ... Suppose I'm interested in searching a table for all records with last names that contain "sh". How would I do that? (Different pr

Searching Fields for a SubString

ill be O(N) unless indexing of some kind is used. My explanation above might be confusing, so let me give an example that will give the same answer ... Suppose I'm interested in searching a table for all records with last names that contain "sh". How would I do that? (Different problem, same answer.) Thanks, Dave.

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/

Searching for a MySQL Admin at TiVo

If anyone would be interested in a contract, please contact me! Thanks! Leann Das Recruiter, TiVo http://www.tivo.com/ [EMAIL PROTECTED] Phone: 408-519-9134 Get the inside track to great jobs at TiVo

Re: Searching through an alphabetical range

an 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 alpha

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 Subjec

RE: Searching through an alphabetical range

im Lucia Subject: Re: Searching through an alphabetical range Its working fine for me: mysql> SELECT DISTINCT email_address FROM mailing_list WHERE marketing_list LIKE 'Y' AND last_name >= 'm' AND last_name <= 'z'; 26371 rows in set (1.00 sec) Thank You, -- Paul

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

Searching through an alphabetical range

Dear All, I need to write a query that searches last names between the ranges of m through z. Is there a way to do this in the query? Thank You, -- Paul Nowosielski Webmaster office: 303.440.0666 ext 219 cel: 303.827.4257 -- MySQL General Mailing List For list archives: http://lists.mysql

Re: Problem searching in grouped rows

Brent Baisley schrieb: I'll give it a shot. First, select the people that got the first advertisement: SELECT c_id,aa_id FROM adverticelink WHERE aa_id=4 From that result, you want to additionally filter out who didn't get the second advertisement. Since that information is contained in the

Re: Problem searching in grouped rows

1 LEFT JOIN adverticelink AS a2 ON (a1.c_id=a2.c_id AND a2.aa_id=6) WHERE a1.aa_id=4 AND a2.aa_id IS NULL That should work in 3.23. - Original Message - From: "Barry" <[EMAIL PROTECTED]> To: Sent: Monday, June 26, 2006 3:58 AM Subject: Re: Problem searching in grouped r

Re: Problem searching in grouped rows

Barry schrieb: Hello everyone! I have a problem with matching in grouped rows. I have: - one DB with customers - one DB with advertisement articles - one DB that holds what customer got which article the linked DB looks like: CREATE TABLE adverticlelink ( c_id int(11) NOT NULL, aa_id int(

Problem searching in grouped rows

Hello everyone! I have a problem with matching in grouped rows. I have: - one DB with customers - one DB with advertisement articles - one DB that holds what customer got which article the linked DB looks like: CREATE TABLE adverticlelink ( c_id int(11) NOT NULL, aa_id int(11) NOT NULL,

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

nough. We do that on our site, and fulltext searching rarely shows up in our slow query logs. But this advice is worth exactly what you're paying for it, so there you have it. -Sheeri On 5/5/06, Steve <[EMAIL PROTECTED]> wrote: Hi Sheeri: Yes, you are misunderstanding my question. I ce

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

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

Searching a large table

All: I am developing a search engine and using MySQL as the backend database management system. Under normal circumstances, when users search through large volumes of records on a search engine site, the results are broken down into pages. When a user clicks on the 'Next' link, the system will r

Re: searching for words with special chars

To: mysql > From: Octavian Rasnita <[EMAIL PROTECTED]> > Subject: searching for words with special chars > > Hi, > > Is it possible to create a query that searches for records which contains > words with special chars and with their english correspondents? > > For e

searching for words with special chars

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 words: mata măta mâţa mâţă (just like Google does). Is it

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

searching in an 'AND' style of query

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 name blahblahblah con

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...)?

searching through a mysql db/tbl

hi... i'm trying to figure out how to approach/solve a few issues. looking through google hasn't made the light shine!! 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: name email

fulltext searching using special chars

Hi, I am trying to search for a word that contains special chars like ş or ţ, but I find only the words and like when the special chars are not a part of the word. I found that if I search for "ş" (in boolean mode), I am able to find the records that contain the

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

Searching "IN" a comma separated list

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_groups and f_images f_u_groups contains the user's

searching work and friends

Sir I had found your address by Denise Johnston from HIMAA.She asked me to write you in order to give me some explanations about research work and friends from your University Thank you I hope to read from you soon. ---

RE: Newbie: Searching for empty fields

On Wednesday, March 23, 2005 12:13, Graham Anderson wrote: > how do you search for an empty field ? > I want to filter out records where the ipAddress field is empty > > SELECT * FROM 'userLog' WHERE 'ipAddress' IS [empty] ? Searching for NULL's -- SEL

Newbie: Searching for empty fields

how do you search for an empty field ? I want to filter out records where the ipAddress field is empty SELECT * FROM 'userLog' WHERE 'ipAddress' IS [empty] ? many thanks g -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAI

Re: Primary Keys, Multiple Index and Searching

Hello. > So in this case MySQL will choose to use the largest index that suits MySQL will choose index which returns less rows. > Given the high cardinality of `manufacturer` Cardinality - the number of unique values in the index. So manufacturer index usually has low cardinality and k

Re: Primary Keys, Multiple Index and Searching

Gleb Paharenko wrote: Hello. If you have a separate indexes on section and status columns, MySQL will use only one of them. And as the column status has very small number of possible values the cardinality of separate index on it will be too low and optimizer won't use this index. I think, if slow

Re: Primary Keys, Multiple Index and Searching

ndexes for section are being duplicated, which I > suppose is a waste of space, and slows the updates (although that's not > a problem, as updates aren't anywhere near as common as searches). > > However, would it be better to knock `section` out of news_search and &g

Primary Keys, Multiple Index and Searching

exes for section are being duplicated, which I suppose is a waste of space, and slows the updates (although that's not a problem, as updates aren't anywhere near as common as searches). However, would it be better to knock `section` out of news_search and have just `status`? Do

Re: Strange issue with fulltext searching (is "self" reserved)?

//dev.mysql.com/doc/mysql/en/Fulltext_Fine-tuning.html> for the details. Michael Jeremy Durham wrote: I have a problem with searching for a specific term. I have a database of about 50k names, and am attempting to search the lastname field for 'self'. My query looks something li

Strange issue with fulltext searching (is "self" reserved)?

I have a problem with searching for a specific term. I have a database of about 50k names, and am attempting to search the lastname field for 'self'. My query looks something like this: SELECT * FROM users where MATCH (first_name, last_name) against ('self'). This query wor

Re: Full text Searching on C#, C++

Brent Baisley <[EMAIL PROTECTED]> wrote on 07/01/2005 17:03:36: > I'm having a lot of trouble trying to get this to work. I've set the > minimum word length to 2, restarted MySQL and rebuilt the indexes, but > can't seem to get this to work. Is it because MySQL is not indexing # > and ++? I can

Full text Searching on C#, C++

I'm having a lot of trouble trying to get this to work. I've set the minimum word length to 2, restarted MySQL and rebuilt the indexes, but can't seem to get this to work. Is it because MySQL is not indexing # and ++? I can't seem to find a setting to alter this behavior. The only other thing I

searching every occurrence of a term in a text field

Hi all having a table with one text field in which I store text (sic!) I need to extract from it every occurence of a term (or a phrase) with its context, litteraly extract 30 char before and 30 char after the term I have searched. thx for any suggestions ciao Mario -- MySQL General Mailing

searching every occurrence of a term in a text field

Hi all having a table with one text field in which I store text (sic!) I need to extract from it every occurence of a term (or a phrase) with its context, litteraly extract 30 char before and 30 char after the term I have searched. thx for any suggestions ciao Mario -- MySQL General Mailing

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

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

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 'Peter' with 'Paul' - can I do this purely with SQL? I know I could do it in PHP fair

  1   2   3   4   >