RE: preg_replace in update statement

2012-03-09 Thread David Lerer
Try with a combination of functions LOCATE and SUBSTR. Locate will return the positions for WordA and WordB within the original text, and, SUBSTR will allow you to string what you you need all together. David. On Thu, Mar 8, 2012 at 4:11 PM, Hank wrote: > I have a simple problem: > > I have a

Re: query problem with null

2012-03-09 Thread Johan De Meersman
- Original Message - > From: "David Lerer" > > Have you tried to set city = null (i.e. without the quotes)? Spot on, I'd think. NULL values are not a string with "NULL" in it - that's only what it looks like in query results :-) An empty string ('') is to strings what 0 (zero) is for

Re: query problem with null

2012-03-09 Thread Richard Reina
Ahhh... Thank you, that was exactly what the problem was. I will fix the code that is setting the value of these new records to 'NULL'. Thank you. 2012/3/9 David Lerer > Have you tried to set city = null (i.e. without the quotes)? David. > > > > -Original Message- > From: Richard

RE: query problem with null

2012-03-09 Thread David Lerer
Have you tried to set city = null (i.e. without the quotes)? David. -Original Message- From: Richard Reina [mailto:gatorre...@gmail.com] Sent: Friday, March 09, 2012 4:24 PM To: mysql@lists.mysql.com Subject: query problem with null When I do the following query: SELECT * FROM

Re: preg_replace in update statement

2012-03-09 Thread Baron Schwartz
You may find this helpful: http://www.mysqludf.org/lib_mysqludf_preg/ On Thu, Mar 8, 2012 at 4:11 PM, Hank wrote: > I have a simple problem: > > I have a varchar field in the database, and I want to remove all text > between WordA and WordB, including WordA and WordB, leaving all text > before Wo

query problem with null

2012-03-09 Thread Richard Reina
When I do the following query: SELECT * FROM geo_trivia WHERE city IS NULL; certain columns that DO have 'NULL' value for city and not a '' (blank) value do not show up. I have even gone to the extent of reseting these records value as ='NULL' with UPDATE and they are still are not selected when

RE: A Blob That's a String??

2012-03-09 Thread Jack Hatterly
> Date: Fri, 9 Mar 2012 13:43:11 +0100 > From: h.rei...@thelounge.net > To: mysql@lists.mysql.com > Subject: Re: A Blob That's a String?? > > where is the difference of "binary" and "string" after fetch it from DB? > the result IS a binary safe string! However, when I change this line in my code

Re: A Blob That's a String??

2012-03-09 Thread Reindl Harald
Am 09.03.2012 13:28, schrieb Jack Hatterly: > Even when I hard code in the correct values I get this error. However, when I > select * from pics, where there is only one longblob in the table, it prints > out a tremendous load of data which indicates to me that a binary file has > indeed been

A Blob That's a String??

2012-03-09 Thread Jack Hatterly
Hi; I have loaded an image from a form into MySQL using Python as a longblob. Here is my table: mysql> describe pics; +-++--+-+-++ | Field | Type | Null | Key | Default | Extra | +-++--+-

ANN: Code Factory for MySQL 12.3 released

2012-03-09 Thread SQL Maestro Team
Hi! SQL Maestro Group announces the release of Code Factory for MySQL 12.3, a powerful Windows GUI solution aimed at the MySQL queries and scripts development. The new version is immediately available for download at http://www.sqlmaestro.com/products/mysql/codefactory/ Please also note that bef