sql query

plisken

Hi. I have a field in my (mysql) table that is called 'cat'. This field contains a comma separated list of numbers, like this: '1, 15, 21' or '13, 15' or '82' etc. I need to create an sql that brings back all the records that contain the number 15 in the 'cat' field.

I tried something like this:
SELECT
*
FROM
myTable
WHERE
'15' IN cat
ORDER BY

id

But it didn't work.. Does anyone know how to do this?

bvogt

SELECT * FROM myTable WHERE cat like '%15%' ORDER BY id

plisken

If it was only that easy... That query will bring back every field that contains 15. Like '156' or '1111111577' or '1515'

bvogt

then lose the %s

SELECT * FROM myTable WHERE cat like '15' ORDER BY id

tomhath

Why use IN at all?

SELECT * FROM myTable
WHERE cat = '15'
ORDER BY id

tomhath

Oops, didn't read the original post fully. 🙁

Read up on the REGEX keyword, should be something like this (not tested):

SELECT * FROM myTable
where cat REGEX '\b15\b'
order by id

http://www.mysql.com/doc/en/String_comparison_functions.html