Using LIKE in SQL Server to identify strings -


i writing program performs operations on database of football matches , data. 1 of issues have source data not have consistent naming of each team. leyton orient appear l orient. of time team listed l orient. need find closest match team name when not appear in database team name list appears in data importing. in database have table 'team' data sample follows:

teamid  teamname    teamlocation 1       arsenal     england 2       aston villa england 3       l orient    england

if name 'leyton orient' appears in data being imported need match l orient , teamid 3. question is, can use function achieve in case team name longer name in database? have figured out if had 'leyton orient' in table , importing 'l orient' locate correct entry with:

select teamname team teamname '%l%orient%';

but can other way around? also, have example manchester united , want import man utd. find putting % sign between every character this:

select teamname team teamname '%m%a%n%u%t%d%';

but there better way?

finally, , might better put in question, not have search correct team when way team named repeated, i.e. store alternative spellings/aliases teams in order find correct team entry quickly. can advise on how might approach this? thanks

the solution looking full text search, it'll require dba create full text index, however, once there can perform more powerful searches character pattern matching.

as others have suggested, have alias table, contains possible forms of team name , reference that. depending on how search working, may path of least resistance.


Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

inno setup - TLabel or TNewStaticText - change .Font.Style on Focus like Cursor changes with .Cursor -

is possible change .font.style on focus tlabel or tnewstatictext happens cursor when use .cursor ? there no built-in support track mouse hovering in inno setup @ time. however, intercepting window procedure of controls can track yourself. following example need innocallback library: [setup] appname=my program appversion=1.5 defaultdirname={pf}\my program outputdir=userdocs:inno setup examples output [files] source: "innocallback.dll"; destdir: "{tmp}"; flags: dontcopy [code] #ifdef unicode #define aw "w" #else #define aw "a" #endif const gwl_wndproc = -4; wm_mousemove = $0200; type wparam = uint_ptr; lparam = longint; lresult = longint; twindowproc = function(hwnd: hwnd; umsg: uint; wparam: wparam; lparam: lparam): lresult; function setcapture(hwnd: hwnd): hwnd; external 'setcapture@user32.dll stdcall'; function releasecapture: bool; external 'releasecapture@user32.dll stdcall'; func...
Read more