sql - Compare two String with MySQL -

sql - Compare two String with MySQL -

I can not compare two strings in a SQL request so that I can recover the best match, its purpose is to Operator is the best zip code possible. For example, in France, we have an integer zip code, so I made a simple request:

  SELECT * to myTable by ORDER stomach (zip_code - 75000)

This request first returns the data of Paris's closest data.

Unfortunatelly, the ZIP code is AB421RS in the United Kingdom, so my request can not do this: I see a difference 'function' in SQL Server:

but I use MySQL ..

Is there someone who has a good idea to move in a simple request?

PS: Levenshtein will not do this distance, because I actually wan't like to compare wire if they were numbers. ABCDEF should be close to AWXEZ compared to ZBDDEF.

OK, I must stop asking questions only after the answer !!

For the community, this is what I will do:

  select * abs from myTable order (ascii (substring (zip_code, 1,1) - esi (astrati) ('AAAAAA', 1,1))) ACC, ABS (ASCII (AZRoad, 2.11)) - ASI (AASAA (substring (zip_code, 3,1)) - ascii ( ASCI (Astrais ('AAAAA', ASCI (AAAAAA, 5,1)) ACC (AAAAAA, 5), ASCI (Substring (Zipcode, 4,1)), substring ('AAAAA', 3,1) ACC, ABS 1)


















Get link





Facebook





X





Pinterest





Email





Other Apps




Comments





Post a Comment







Popular Posts




Unable to get a fresh ASP.NET MVC project running with Visual Studio
2008 -



    This is a very basic question. I'm asking this silly about this, but I'm stuck something else and hopefully That something here can save me some time. So I open VS2008, to download the new ASP.NET MVC web application and click OK I want to prepare a test project. I debug my new MVC project to hit F5 then I enable the debugging to the web. I choose to modify the config file. It goes where I get a page load error.   Firefox can not establish a connection to the server on the local host: 57323.   Do I have to do something special for Vista? Or I should do something with IIS   Thanks for helping a noob   6/30/2009 update   OK, I think that I VS2008 may need to be reinstalled with the ASP.NET Development Server port. I have tried to do everything that I have suggested. I've marked Default.aspx as the start page. I tried to open it in Firefox / IE 8 / and Chrome. I tried to uninstall / reinstall ASP.NET MVC, which was not working. I tried telnetting with Putin with a local ho...






delphi - Mouseover hint for TChart series value -



    I am using a TChart in Delphi 7, and I want to display charts sometime. I am using the following code to set the chain value to a database query:    chart1.FreeAllSeries; Chart1.SeriesList.Clear; Chart1.AddSeries (TBarSeries.Create (self)); TBarSeries (chart1.Series [0]) BarStyle :. = BsRectGradient; Stop starting with Query 1; Executed; While EOF does not start chart1.Series [0]. Add (field 'flags' ('sum_actual_days'), Field Astrstring ('contract_no')); the upcoming; End; End;    Each time (value) is now showing both the label below the bar and in a yellow rectangle above the bar.   Rather than repeating the amount of label twice, I have some additional information from the query that I would like to show above the bar rather than the label (or, preferably, as a mouseover signal). Can it be done with TChart? And how ...?      This can be done with a TChart using the onMouseMeave event of the chart. Something like this should start with you:    Process TForm...






sql - Incorrect syntax near the keyword 'table' -



    I'm getting this error what I'm doing is trying to get data from a table and a db and Keep it in another DB and table. The tables are not exactly the same, I am using a FETCH cursor, so I get the first line from the DB1 table and then keep each column value in the declared variable. Then I run an assembly statement in db2 table and get the next value. All of these are working properly because it runs properly, but in the end I get this error,   Wrong syntax near the keyword 'table'.   In the entire transaction details, an attempt / catch with the error of expression in the Cat block, apart from this, I do not know what is the reason for it.   Here is the code    added to prevent additional result set at SET NOCOUNT - Interfering with the SELECT statement. Set nosenate on; TRY begin transaction sets ITENDITY column off --TURN identity_insert [dB] start [dbo] [TEST] all CONSTRAINTS table --TURN [dB] change [dbo] [TEST] NOCHECK barrier All -.... Insert statement here @...








Powered by Blogger