Charlie Schaubmair wrote:
> Hello,
>
> I want to do a query where I only gt the results by a numeric value:
>
> select * from MyTable where 1 IN someFieldInMyTable
> I know this query doesn't work, but maybe anyone knows what I mean.
>
> 1 can be a value betwenn 1 and 23
> someFieldInMyTable is n
Sorry, query was wrong... has to be:
SELECT *, CONCAT(',',someFieldInMyTable,',') as wherefield FROM MyTable
WHERE wherefield LIKE '%,1,%'
Mike van Hoof schreef:
Hey Charlie,
maybe there is, but i don't know why... because when you do a like
query it also finds the 21 when you do a like on
Hey Charlie,
maybe there is, but i don't know why... because when you do a like query
it also finds the 21 when you do a like on the 1.
what you maybe can do (not tested) is:
SELECT *, CONCAT(',',someFieldInMyTable,',') as wherefield FROM MyTable WHERE
wherefield='%,1,%'
Now your someFieldIn
