Search results for query: *

Ok Thanks ingresman. Ill try your method :)

Well i use MySQL server on my PC and MySQL-front to manage the SQL & data which is good (and fast) - data file is 130Mb. Anyway what your script does is trim off the "ltd" from any company name with "ltd" and writes out a delete script; delete from <tab> where companyname = 'company', which i...

Ok I get it. If the title doesnt exist after the ltd is trimmed, it wont be deleted. In this case I cant really use id using this method.

Thanks ingresman, I have around half million records to check so manual is just not an option for me. I tried the SQL and it doesnt quite do the job becasue it just gets every case of LTD which means i would be deleting any record whith LTD at the end. I need to keep the record with the ltd...

Also in some cases there are two or more records where companies have the "Ltd". (they operate in different locations) So how can adjust this so where there are two or more companies one remains? Sorry, Im on my learners permit with SQL - I only know the basics.

Pretty neat solution ingresman, thanks :) Only issue here is that there can be more than one occurrence of the same company. ie - I may end up with with a result like; delete from table where company='companyname' delete from table where company='companyname' delete from table where...

Typo... Companyname Companyname Ltd

Hi, I have been given the task of cleaning up a list of company data. Ive removed all the duplicates and done some tidy ups but I have an issue I cant work out. The problem is that there are company names that are the same except for where this example occurs; Companyname Companynane Ltd...