full text search

ave to search a longtext field.) So should I consider fulltext searching? Do I have to build an index first and how often is it updated etc? -- zzapper Success for Techies and Vim,Zsh tips http://SuccessTheory.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Calling MySQL often risk of performance problems?

askets/CMS systems for smaller client websites etc where speed is not the top criteria. What are your views/experience. -- zzapper Success for Techies and Vim,Zsh tips http://SuccessTheory.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: Comparing Numbers in Text Fields

On Wed, 12 Oct 2005 13:27:52 +0200, wrote: >zzapper wrote: >> Hi, >> Recently had a few problems with comparing numbers stored in text >> mysql fields char(2), which I solved by chnging the field to int(1) >> >> Now my question is why do you sometimes "a

Comparing Numbers in Text Fields

Hi, Recently had a few problems with comparing numbers stored in text mysql fields char(2), which I solved by chnging the field to int(1) Now my question is why do you sometimes "appear" to get away with this? -- zzapper Success for Techies and Vim,Zsh tips http://Success

myisam or innodb (chestnut)

back, but that MYISAM is quicker. Is myisam still dominant for web applications? -- zzapper vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?" http://www.rayninfo.co.uk/tips/ vim, zsh & success tips -- MySQL General Mailing List For list archives: http://lists.

Re: Avoiding complex mysql selects

so limitations >you need to be aware of, like no relevance when searching in boolean >mode, can't be used on InnoDB tables, etc. > O gosh my learning curve Thanks -- zzapper vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?" http://www.rayninfo.co.

Re: Conditions in selects

0 (false) if either sale_start or >sale_end is 0, otherwise it will be 1 (true). Then you are missing the 'AND >max_value' part. > >Michael Could we have the corrected sql here pls? I guess SELECT IF(NOW()) BETWEEN sale_start AND sale_end,'no','yes'

Re: Avoiding complex mysql selects

On Tue, 12 Jul 2005 18:34:38 -0400, wrote: >H, how about using full text indexing? It will be a lot easier >to implement and a lot quicker. > > Can you give more details? -- zzapper vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?" http://w

Avoiding complex mysql selects

__ and ( ( (synopsis like '%$key1%') or (titlelike '%$key1%') or (keywords like '%$key1%') ) and ( (synopsis like '%$key2%') or (titlelike '%$key2%') or (keywords like '%$key2%') ) ) __SQL__; } -- zzap

Update query to set random data

nyone got any other useful queries in this line? -- zzapper vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?" http://www.rayninfo.co.uk/tips/ vim, zsh & success tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

Re: Records which link to other records in same table

-children table eg father 234 child 450 father 234 child 451 father 234 child 453 mother 235 child 450 mother 235 child 451 mother 235 child 453 Now would it be useful to have a couple identifier? to simplify the above -- zzapper vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()]

Records which link to other records in same table

hips/linking the wife/father/mother/children fields and the recordid of other records I'm fogging on this, your advice pls -- zzapper vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?" http://www.rayninfo.co.uk/tips/ vim, zsh & success tips -- My

Re: Using MySQL to store/archive code/html etc?

of html. and already use Googles Desktop Search, plus my own Intranet Search grep,find, etc. Now amongst other problems these pages have non-unique names index.html etc. I feel the question of whether I should be using VCS is another issue, probably should be! I 'm searching for another level

Using MySQL to store/archive code/html etc?

more time going thru CD backups etc than it would take to start again. I've postulated using MySql as a store for such pages. but is a database suitable for storing, searching for and retrieving such information.??? Your eminent opinions and experiences desired!! -- zzapper vim -c &quo

Re: Cleaning muck out of data fields

>+--+ >| 10.95 tiitti | >+--+ >1 row in set (0.09 sec) > >mysql> select '10.95 tiitti'+0 from dual; >+--+ >| '10.95 tiitti'+0 | >+--+ >|10.95 | >+--+ >1 row in set (0.

Cleaning muck out of data fields

#x27;t think of a way. I have the same problem if I try to "Locate" I cant AFAIK say locate first digit. Comments/Ideas? Q2) Can I match mucky non-alphanumerics ? -- zzapper vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?" http://www.rayninfo.co.uk/tips

Re: query to lowercase database columns names

` `p01_desc` varchar(255) default NULL, change `01_lLcode` `p01_lcode` varchar(255) default NULL, etc eg VIM commands :%s#^[^ ]\+#change & p\L& :%s# p`# `p# This worked very well -- zzapper vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?" http://www.rayninfo

Re: query to lowercase database columns names

+-+--+-+-+---+ >1 row in set (0.00 sec) > > >Scripting this query on all tables, and all columns from a perl or php script >can help you > Mathias Yes of course I can use Perl to generate a multiple MySQL Alter script rather than actual

Re: query to lowercase database columns names

l columns beginning with a numeric form ^\d.* to someprefix_& Is it not possible to write such a query, or is this best done by Perl or PHP script? -- zzapper vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?" http://www.rayninfo.co.uk/tips/ vim, zsh & s

query to lowercase database columns names

Hi, Is there a query which will "alter" a table to rename all the columns to lowercase eg Price to price, Quantity to quantity -- zzapper vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?" http://www.rayninfo.co.uk/tips/ vim, zsh & success tips -

Re: Data Design : Numeric or keyword lookup values?

e issues etc. > >Charles Walmsley Charles, The data-entry needs to be controlled whether numeric or keyword, usually by drop-down. I will come to some conlusion with my present complex, where I will designing my database from scratch. -- zzapper vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zb

Data Design : Numeric or keyword lookup values?

here anything wrong with using 2nd method? Views/opinions please -- zzapper vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?" http://www.rayninfo.co.uk/tips/ vim, zsh & success tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Multi Table Delete in 3.23.47

x27;t work out which bit the doc refered to. BTW Whinge is a rather a mild term in the UK, -- zzapper vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?" http://www.rayninfo.co.uk/tips/ vim, zsh & success tips -- MySQL General Mailing List For list archives

Re: Multi Table Delete in 3.23.47

Hi, Final whinge: I wish the mysql website made it a little clearer which features are recent additions, I suggested color coding. BTW regards multi table deletes there's something nasty there between 4.0 and 4.1 -- zzapper vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)

Re: Multi Table Delete in 3.23.47

On Wed, 27 Apr 2005 09:50:37 +0100, wrote: >zzapper wrote: >> On Tue, 26 Apr 2005 23:22:46 +0100, wrote: >> >> >>>Hi, >>> >>>The following query runs fine in recent versions of mysql 4.1x etc >>> >>>delete from t2 using

Re: Multi Table Delete in 3.23.47

in 3.23.47 I can't find any reference in the manuals to why this might >be. > >Is there any change in syntax which will make the query work in 3.23.47? I mean how did you do this before 4.x?? -- zzapper vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?&

Multi Table Delete in 3.23.47

. Is there any change in syntax which will make the query work in 3.23.47? -- zzapper vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?" http://www.rayninfo.co.uk/tips/ vim, zsh & success tips -- MySQL General Mailing List For list archives: http://lists.m

General substring update query required

Hi, I want to replace every occurence of a string with another. The following query works fine (appears to anyway) update tbl_websitepages set page_content=replace (page_content,'develop','bucket'); But is there any way to get any Regexp into the substitution? -- MySQL General Mailing List F

Re: "Repairing Data" packing with zeros

On Fri, 25 Mar 2005 12:03:26 -0500, wrote: >zzapper wrote: > >> ONE1-> ONE0001 >> ABC23 -> ABC0023 >> FGH123 -> FGH0123 >> >> What Update Query should/could I have used? > >Something like this perhaps? > >UPDATE table_name SET

"Repairing Data" packing with zeros

Hi, I needed to repair some data that had been entered inconsistently, I was in a rush so I did it manually via SqlYOG. (too much of a rush to consider how to do it quickly!) The bad data in one column propertyID was of kind \w\w\w\d eg ONE1 \w\w\w\d\d eg ABC23 \w\w\w\d\d\d eg FGH123 when the

Why are my tables read only?

Hi, After upgrading to mysql 4.1.10nt I am being told that some of my tables are read-only I cannot find where or how you might specify that a table is read/write to whatever -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

Upgrading to MySQL 4.1X Win32 Horror

l, the commands look like this: C:\> C:\mysql\bin\mysql -u root -p mysql mysql> SOURCE C:\mysql\scripts\mysql_fix_privilege_tables.sql Just ran this made no difference! YUK YUK YUK zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T])

Re: Is there a Library of complex queries/inserts/queries?

tc >From Shantanu http://en.wikibooks.org/wiki/Appendix mysql statement examples zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL Gen

Is there a Library of complex queries/inserts/queries?

Hi, Sometimes an example is worth a 1000 words. Does anyone know of a website with lists of mysql statement examples? ie a list of queries, a list of updates, list of inserts from simple examples to joins regexps etc zzapper (vim, cygwin, wiki & zsh) -- vim -c &q

Re: Filtering non-ascii characters from mysql data, null, tab etc

On Fri, 11 Feb 2005 18:41:38 -0500, wrote: > >zzapper wrote: > >> On Fri, 11 Feb 2005 12:46:29 +0100 (CET), wrote: >> >> Tom adapting your script, >> >> create table test (txt varchar(255)) Type=MyISAM; >> insert into test values('Some Text\

Re: Filtering non-ascii characters from mysql data, null, tab etc

hing else Turns out my rotten character (they all seem to display as a hollow box) was a \r thanx zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips --

Re: Filtering non-ascii characters from mysql data, null, tab etc

hing else Turns out my rotten character (they all seem to display as a hollow box) was a \r thanx zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips --

Re: Filtering non-ascii characters from mysql data, null, tab etc

've googled and just found a few fellow searchers!! (I will probably have to dump the db and use a perl script!) zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best

Filtering non-ascii characters from mysql data, null, tab etc

ested to know the syntax to filter null characters. Secondly I'd be interested in a general filter for non-ascii. cheers zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg?" http://www.vim.org/tips/tip.php?tip_id=305

Re: Perl Script to transform a MySql insert into an update

insert into an update statement # zzapper [EMAIL PROTECTED] # NB does not handle any commas in strings etc $insert_str=q|(fred,joe) values ('$fred','$joe')|; $_=$insert_str; s#^\s*\(([^)]+)\)##; $set_str=$1; s#values\s+\(([^)]+)\)##; $values_str=$1; @set_array=split(/,

Perl Script to transform a MySql insert into an update

Hi, Does anyone have a Perl Script (or other) to transform a MySql insert into an update (or vice-versa)??? zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg?" http://www.vim.org/tips/tip.php?tip_id=305 Be

Re: A query to swap the data in two fields

gt; >and >> > t2.beds2 to t1.beds >> > do I need to store one of the fields temporarily? >> >>Hey chums you normally get me an answer in minutes, is my question too easy? >>zzapper (vim, cygwin, wiki & zsh) >>-- > >zzapper, > Ge

Re: A query to swap the data in two fields

On Thu, 23 Sep 2004 11:03:08 +0100, wrote: >Hi, > >I want to swap the data in two fields > >eg > t1.beds to t1.beds2 >and > t2.beds2 to t1.beds > do I need to store one of the fields temporarily? Hey chums you normally get me an answer in minutes, is my question too

A query to swap the data in two fields

Hi, I want to swap the data in two fields eg t1.beds to t1.beds2 and t2.beds2 to t1.beds Do i need to temporarily store one of the fields (thinking like a programmer)? Can you suggest what query I need here pls? zzapper (vim, cygwin, wiki & zsh) -- vim -c &q

Re: Understanding Joins : Baffled

t my understanding will now (hopefully) leapfrog. It's always a struggle when you are at such a low level of your learning curve that you cannot easily formulate your pleas for help!! zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:

Re: Understanding Joins : Baffled

ault NULL, `dtmDevDate` datetime default NULL, `dtmDevDateLastUpdate` datetime default NULL, `txtDevDivision` varchar(30) default NULL, `txtDevAddress` text, `intDevStage` smallint(6) default NULL, `txtDevPostCode` varchar(20) default NULL, `txtDevCity` varchar(40) default NULL, `txtDevRegio

Understanding Joins : Baffled

ON dev.IDurl1 = url.intID WHERE intDevID = #intDevID# But that only "Joins" one record. and I cant understand how I would access the results of the query Baffled help!!! zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|

Is it possible to have Undeletable Records?

extra boolean field "Record Read only", but is there anyway to specify at the data level? zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips --

Re: Using REGEXP

LECT t1.* > FROM ytbl_development t1 > INNER JOIN tmpShortCodes sc > ON t1.txtDevPostCode LIKE concat(sc.short_code, '%') > >and this query would use indexes on txtDevPostCode and short_code. Thnx to all for this mysql primer, will let you know how it goes, but have been

Re: Using REGEXP

;t use mid as I can't guarantee that the length of a short postcode is 5 chars How would you solve this problem (The list of short Area Postcodes is generated by an earlier query) zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggV

Re: Using REGEXP

On Tue, 29 Jun 2004 15:13:10 -0400, wrote: >zzapper: > >I could be reading it wrong, but it looks like you're looking for the >result of your REGEXP in a list. REGEXP returns only a 0 or 1, not the >expression resulting from performing a REGEXP. > >Wes > >On J

Using REGEXP

code contains a list of "short" postcodes OX14 1,OX14 2 etc whereas t1.postcode contains full postcodes OX14 5RA (If qryRadius.shortpostcode wasn't a list I'd be able to use LIKE) How can I write a Where clause that gets round this MySql 4.018 zzapper (

Using REGEXP

code contains a list of "short" postcodes OX14 1,OX14 2 etc whereas t1.postcode contains full postcodes OX14 5RA (If qryRadius.shortpostcode wasn't a list I'd be able to use LIKE) How can I write a Where clause that gets round this MySql 4.018 zzapper (

Re: Mysql for Family History (genealogy)

ember that they are playing around with using a database (right now, >only in CVS). Don't know if it's specifically MySQL or not. The current >release of GRAMPS stores its information in an XML file. > I'm looking for something a little simpler. I just thought somebody m

Re: What is your mysql debugging strategy?

u just drop you query. THis >would output the problem to the page. Dead simple and quick. > >Rich > >Joshua J. Kugler wrote: > >> On Tuesday 27 April 2004 04:26 am, zzapper said something like: >> >>>Even though I solved the following problem myself, I&#

Re: storing

not sure abt this. > >Thanks, >liz Liz, You can do this, but I'd rather store them as a script eg with mysqldump zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of

Mysql for Family History (genealogy)

Hi, Anyone designed a MySql database for family history? Any ideas,recommendations, problems ? zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL G

What is your mysql debugging strategy?

ubProjectID,>>>>sp. *<<<< FROM tbl_subproject AS sp INNER JOIN tbl_projectstatus AS ps ON sp.ProjectStatus = ps.ProjectStatus LEFT JOIN tbl_invoice ON sp.SubProjectID = tbl_invoice.SubProjectID WHERE (tbl_invoice.SubProjectID Is Null) AND (sp.ProjectID=1) AND (sp.Deleted=0) AND (ps.Inv

Sub-select & Inner Joins

hargeID ) ON p.ProjectID = sp.ProjectID WHERE ut.reportDisplay = 1 zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list

Re: Complicated Inner Joins

From# And #datDateTo#) ) AS pr ON sp.SubProjectID = pr.SubProjectID) ON ut.Unit = pr.Unit ) INNER JOIN tbl_RateTypeCategoryCharge AS rt ON pr.RateTypeCategoryChargeID = rt.RateTypeCategoryChargeID ) ON p.ProjectID = sp.ProjectID WHERE ut.reportDisplay = 1 zzapper (vim

Re: Complicated Inner Joins

for Advanced Technology Environments >p: 212.759.6400/800.759.0577 Brent, Will try that out, I inherited the code, and am also a Join Newbie, it did work on MSAccess that's all I know zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig

Complicated Inner Joins

.InvoiceStatus) ON p.ProjectID = i.ProjectID) LEFT JOIN tbl_subproject ON i.SubProjectID = tbl_subproject.SubProjectID WHERE i.InvoiceStatus Not IN('Show All') AND i.ProjectID =-1 AND i.Deleted = 0 Order BY si.Orderby ,i.InvoiceNumber zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s/

Re: Please help with syntax for mysqldump

On Tue, 13 Jan 2004 14:07:38 +, Matthew Stuart <[EMAIL PROTECTED]> wrote: Similarly. SELECT intDEVID,txtDEVPOSTCODE INTO OUTFILE "c:/aaa/dump.sql" from ytbl_development; (dump.sql file must NOT already exist) zzapper (vim & cygwin & zsh) -- vim -c ":%s/^/Wh

Re: Please help with syntax for mysqldump

I am doing right, but could somebody email me the full syntax >to use which comes after the mysql> mysqldump -udavidrayner -pdavidrayner eeetic > eeetic.sql mysqldump -udavidrayner -pdavidrayner -A > all.sql zzapper (vim & cygwin & zsh) -- vim -c ":%s/^/WhfgTNabgureRIv

Table/Column Name Completion

Hi Ya I believe the Dos Mysql Client has limited table name completion, but do any of the GUI Clients have this feature?? zzapper (vim & cygwin & zsh) -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" http://www.vim.org/tips/tip.php?tip_id=305

Automatic Updating of Timestamp

se to automatically mark INSERT or UPDATE operations with the current date and time. If you have multiple TIMESTAMP columns, only the first one is updated automatically. zzapper (vim & cygwin & zsh) -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" http://www.vim.

Re: Converting an Access Table to MySQL

tor, It's at the same URL www.mysqlfront.de I'm not sure it's stable yet zzapper (vim & cygwin & zsh) -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General

Re: Converting an Access Table to MySQL

I post to Usenet to be told there's a better way; thanx. The only advantage of my script is that I could do a fairly complex query to "transform" the data if that were necessary zzapper (vim & cygwin & zsh) -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:nor

Converting an Access Table to MySQL

$company','$contact','$address','$town','$county','$postcode','$tel','$fax','$email','$web'|; $vals.=qq|,'$mysql_timestamp'|; #print $cols; print "\n".$vals; exit; my $sql=qq|insert into $t

Re: MySQL Control Center!!!

documentation, kindly direct me to the URL. > try gmane.comp.db.mysql.mycc (but I don't think there's any doc) zzapper (vim & cygwin & zsh) -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best

Re: Problem With Creating Table

;NULL, article_title VARCHAR(255) NOT NULL, >last_post_member_name VARCHAR(79) NOT NULL); Caroline, Maybe you should be putting long sql statements into an external script eg $ mysql -D mydb -u test -ptest < create_table.sql zzapper (vim & cygwin & zsh) -- vim -c ":%s/^/

Re: Comparing strings containing possible quotes

rics from the input string? What is the syntax? I've previously wanted to do a regexp on the input string but this not seem to be permitted zzapper -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips

Re: Comparing strings containing possible quotes

??? zzapper -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Comparing strings containing possible quotes

On Mon, 08 Dec 2003 19:07:43 +, zzapper <[EMAIL PROTECTED]> wrote: >Hi Ya, >I have a typical select as follows > > SELECT * FROM ytbl_development AS t1 > WHERE (t1.txtDevName LIKE '%#form.searchtext#%') >B) >Now I can filter any quotes from form.

Comparing strings containing possible quotes

seeing how you solve this. zzapper -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How do test unique values in a MySql column?

Hi Y'All I need to test if any values in a column are the same (or are unique) eg (my made up syntax "Unique") SELECT * from tbl_addresses WHERE txtName is UNIQUE; How should this be done??? zzapper -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?&

mysqlfront versus mysqlcc

I currently use the excellent mysqlfront which is sadly no longer supported. I've tried mysqlcc but it seems non-intuitive, and missing loads of features. It also has a problem working with old versions of mysql 3.23<.47 Or have I missed something, does anyone recommend mysqlcc???

How can I become an Expert MySql User?

of DBs No rude answers please zzapper -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Why is there no REGEXP()?

devPostCODE) before doing the comparison, I seem to need some kind of inner query. can U help? zzapper -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives:

Why is there no REGEXP()?

This use of REGEXP doesnt exist AFAIK , what work arounds exist, or how would you do it? BTW the QuotedValueList contains "Short Postcodes of type AA11 or A11 or AA1 zzapper -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" http://www.vim.org/tips/tip.ph