Monday 15 June 2015

sql - How to query data where value starts with two possibilities (198 or 190)? -


The query below gives me a list of the required data, I need to create it so that it returns the code that Begins with 198 and 190. I just tried to add: 'and ATCocod start with 190' but the result was not found. Currently it does not give any problem to all the data starting from 1985.

Thanks

SELECT% 20ATCOCode% 20FROM% 2015n7Rpi190vjrPcmbiT_hRcZ9JbXE8a_I1euHyg% 20WHERE% 20ATCocode% 20STARTS% 20WITH% 20198 % 20 & amp; Key = AIGSALG-LNNDOQ-WWXNISBXY7GDHT2KIS

Post-text itemprop = "text">

Fusion Tables does not support SQL or So those suggestions are not going to help. The best you can do is start from the price 9 and the post process of the result, at least if it is a string value, if it is a number then you get the values ​​& gt; = 190 & lt; By getting the = 198, you can get the same effect.

No comments:

Post a Comment