12-04-2017, 05:13 AM
Join Date: Apr 2009
Location: Merseyside Uk
OS: Windows 10
As my project gathers pace I have noticed that some users are inputting Aircraft Models (field is "model") as -
What I want to do via a query is to run through these and add a leading "B", for instance the above would be changed to:
What I have in my daily update line is -
UPDATE `spotting` SET `model`='B737-*' WHERE `model` = '737-*';
this doesnt appear to be picking them up, and the "simulate query" also returns 0 rows when i know full well there are (I put some in to test).
Where am I going wrong?
the first few lines of my daily update script is as follows:
UPDATE `spotting` SET `model`='B737-8AS/W' WHERE `model` = 'B737-8AS';
UPDATE `spotting` SET `model`='B737-8K5/W' WHERE `model` = 'B737-8K5';
UPDATE `spotting` SET `model`='B737-%' WHERE `model` = '737-%';
UPDATE `spotting` SET `operator`='United States Airforce' WHERE `operator` = 'US Airforce'
Everything else appears to be working fine